Database Synchronisation

Database Synchronisation

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.

Insert Synchronization
Update Synchronization
Insert Synchronization and Update Synchronization together


1.Insert Synchronization

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.


2.Update Synchronization

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.

3.Insert Synchronization and Update Synchronization together

You have modified your table in your source database. For example, you changed some data in existing records and inserted entirely new records in that table. You have to add these values in the table and renew data in your destination database. Insert Synchronization and Update Synchronization together allow you flawlessly to accomplish complex synchronization.



The best article on Datbase synchronization is available at

http://dbconvert.com/synchronization.php

The best database synchronation tool for mysql database is available at

http://www.sitepoint.com/article/mysql-data-sqlyog-job-agent/1