 |
|
|
|
|
|
|
|
|
Having some new records in the table in your source database, you have an opportunity to add them in the table in your destination database with the help of our converters from Database Conversion Product Line.
Additional records easily and quickly inserted from a source to a destination, in case there are no records with identical Primary key values.
The result of the synchronization is the added records from a source to a destination if there are no coincident records in the last one. The following scheme show a simple example of insert synchronization work.
|
|
|
|
Changing table in your source database, you would like to adjust your table in a destination database to desired result.
Converter will replace the altered records without any problems. It compares the value of records in order to establish identity between two tables.
The result of update synchronization is keeping all your data updated. This is shown schematically in the given below scheme.
|
|
|
|
You have deleted some records in a source database without deleting the corresponding records in the destination one.
With checked Drop-synchronization option, the program will delete records from destination database if these records are not presented or were deleted in source database.
The result of synchronization is the data coincidence between source and destination databases. The situation is shown schematically below.
|
|
|
|
You have modified your table in your source database. For example, you changed some data in existing records, inserted entirely new records in that table and delete unnecessary ones.
You have to add, delete these values in the table and renew data in your destination database.
Insert Synchronization, Update Synchronization and Drop Synchronization all together allow you flawlessly to accomplish full synchronization.
The result of synchronization is identity of the data. Destination database entirely matches the source database. The subsequent process is shown schematically in the following scheme.
|
![](images/z.gif"){kind=small}
