Synchronization
Close Window

Perform Database Synchronization:

  • Configure the Synchronization by selecting the appropriate type.
  • Click the 'Perform Sync' button to sync the master database with the slave database.
  • Click the 'Reset' button to reset the the default connections.
  • The results will be show when complete.

Modify the default Synchronization:

  • Change the connection string for the master and slave databases to sync other databases.
  • Click the 'De-Provision' to remove all the sync provisions from the database and delete the table list.
  • Click the 'Perform Sync' button to sync the master database with the slave database.
  • Default conflict resolution, 'Master Wins', can be changed to your requirements. (Note: 'Custom' is not yet implemented.)
  • Setting 'Log Sync Changes' to true will write changes to the appropriate log file. (????-SyncChangeLog.txt)
  • The log file is located in the 'C:/Temp/Sync' directory of the local server.

Select New SQL Connection:

  • Click the 'Select New SQL Connection' button to open the Select Sql Server section.
  • Select a desired Sql server from the drop down list.
  •  Click the 'Refresh' button to refresh the SQL server list.
  • Select how to log on to the server, using Windows or SQL authorization.
  • SQL Server authorization requires a valid 'User Name and Password'.
  • Select the database name from the drop down list.
  • Click the 'Test Connection' button to ensure that a connection can be made to the selected database.
  • Click the 'Set Master' button to set the Master Database to the selected database.
  • Click the 'Set Slave' button to set the Slave Database to the selected database.
  • Click the 'Cancel' button to close the Select Sql Server section.
Close Window