What data will not be synchronized?
When you synchronize the data sources, bear in mind that some rows may not be synchronized if:
- There are triggers defined on the tables
To work around the issue, select the Disable DML triggers option in the Data Synchronization Wizard before generating a synchronization script.
- Primary keys are defined on columns that have different collations
If you try to compare tables that have primary keys defined on columns with different collations, the results might be unpredictable.
- Tables having nonidentical structures
In case the structure of the tables you are synchronizing is not identical, the outcome might be unpredictable.
Primary keys and indexes that will not be dropped for synchronization
When you select the Disable primary keys and indexes option in the Data Synchronization Wizard, bear in mind that primary keys, indexes or unique constraints that are selected as comparison keys will not be dropped for the synchronization.
Want to Find out More?
Overview
Take a quick tour to learn all about the key benefits delivered by dbForge Data Compare for MySQL.
Request a demo
If you consider employing the Data Compare for your business, request a demo to see it in action.
Ready to start using dbForge Data Compare for MySQL?