Database synchronization is the process of data uploading or mirroring between two or more databases. When you work with converters you can face some issues attempting to synchronize tables in your databases. Here you can find answers how to overcome them.
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 database to a destination, in case there are no records with identical Primary key values.
The result of the database synchronization is the added records from a source to a destination database 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 database drop 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.