Data Synchronization Process Overview

After you have compared data, Data Compare for MySQL gives you an easy and convenient way to synchronize data.

You may manually specify which tables and even which records to synchronize. Use the check boxes in the first column of the data comparison document grid to include or exclude objects to synchronization.

Note that it is highly recommended to backup target database before data synchronization.

If you synchronize data with different data type, you may encounter synchronization warnings. They are displayed at the Summary, Data Synchronization wizard. If you have any synchronization warnings, that means that during synchronizing data you may encounter errors or data loss because of rounding, truncation, etc. For more information about synchronization warnings, read the Synchronization Warnings topic.

The Data Synchronization wizard allows you to either apply updates immediately or create an update script for the Target database and save it to a file. For more information, visit the Synchronizing Databases topic.

Before start the synchronization, you may view Action Plan that contains all the actions that will be performed during synchronization. The action plan represents the synchronization script structure, so it is good to analyze it before this script will be generated or executed if you have chosen to execute the script immediately. The action Plan is displayed on the Summary page of the Data Synchronization wizard.