Data Integrity - XpertLog - Automatic synchronization between the XpertLog local database and the Server SQL database

The purpose of this article is to describe how data is automatically synchronized between locally installed databases and the main shared (server) SQL database without any user interaction.

Database Synchronization

This applies to XpertLog® Software and connected hardware when configured to use a shared SQL database located on a network server where local computers may from time to time need to work without access to the network and hence the main (server) SQL database.

Prerequisites

A license is required for the main shared (server) SQL database.

Operation

The synchronization procedure can be easily setup by the IT department and there is no limit to the number of computers using XpertLog which can be synchronized with the main SQL server database.

Users can start and run a test using XpertLog with or without a network connection. If network connection is unavailable data will be stored in the local database. When network connection is restored and the shared database is once again available, both local and SQL server databases will be synchronized, including the Audit Trail.

No user interaction is necessary as the process is fully automated.

Log on to offline machine

Members may log on using Active Directory or local accounts regardless if network is available or not. The automatic synchronisation is unaffected.

Synchronization between the XpertLog local database and the Server SQL database

Benefits

  • True data synchronisation of all data in local database with shared main database (includes Audit Trail, templates, calibrations, tests, reports, etc).
  • Synchronisation is ongoing and continuous not just a one-shot export from one database and import to another.
  • Data Integrity is assured as completely automated and includes all data in database.
See the Application Note
Read 69 times Last modified on Thursday, 06 August 2020 12:33

Leave a comment

Make sure you enter all the required information, indicated by an asterisk (*). HTML code is not allowed.