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
|
|
|
Select the source database
|
|
|
Select the target database
|
|
|
The program will list the common tables of the source and target databases and will define their identifiers
|
|
|
A specialty of the comparison feature is that the values modified with an expression can be compared as well
|
|
|
Parameters
|
|
|
Comparison of tables
|
|
|
Comparison has finished
|
|
|
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
|
|
|
Data of the source and target databases can be synchronized immediately after the comparison
|
|
|
The synchronization calls the export feature with the records defined by the comparison
|
|
|
Parameters
|
|
|
Data synchronization
|
|
|
Data synchronization has finished
|
|