1. Skip to Menu
  2. Skip to Content
  3. Skip to Footer>

Database comparison, synchronization



Compares two databases that might be derived even from two different types of SQL server. The basis of comparison may be a table name, SQL command, result or comparing buffer as well.
A specialty of the comparison feature is that the values modified with an expression can be compared as well
Another specialty of comparison is that the program finds not only those records between the source and the target databases which are different, missing or new, but you will get the records with double keys, too

Video:








The story of the video in pictures:



Firstly, you have to select the database servers

Database comparison, synchronization

Select the source database

Select the source database - Database comparison, synchronization

Select the target database

Select the target database - Database comparison, synchronization

The program will list the common tables of the source and target databases and will define their identifiers

Database comparison, synchronization

A specialty of the comparison feature is that the values modified with an expression can be compared as well

Database comparison, synchronization

Parameters

Parameters - Database comparison, synchronization

Comparison of tables

Comparison of tables - Database comparison, synchronization

Comparison has finished

Comparison has finished - Database comparison, synchronization

Another specialty of comparison is that the program finds not only those records between the source and the target databases which are different, missing or new, but you will get the records with double keys, too

Database comparison, synchronization

Data of the source and target databases can be synchronized immediately after the comparison

Database comparison, synchronization

The synchronization calls the export feature with the records defined by the comparison

Database comparison, synchronization

Parameters

Parameters - Database comparison, synchronization

Data synchronization

Data synchronization - Database comparison, synchronization

Data synchronization has finished

Data synchronization has finished - Database comparison, synchronization