With Data Synchronization, data are transferred from one database to another with detailed analytical process. You are not only authorized to rollback the transferring process, but also insert, delete and update records to the destination. You can also save the synchronization profile for setting a schedule. Same as Data Transfer, Data Synchronization can be invoked from the command line.

Creating Data Synchronization Profile

1. In Navicat, choose Tools > Data Synchronization > General Settings.
2. Choose the Connection and the Database for the Source
3. Choose the Connection and the Database for the Target
4. After you have selected the Connections and Databases for the Source and Target, you have to map the tables from the Source to the Target.
5. You may click Select All Matches so that Navicat will select all the mappings where the table name in the source is the same as that in the target.
6. Tables which have not been mapped will not be synchronized.
7. Click Start to begin the process.

Preview button - Preview function simulates the data synchronization process. You can preview the result in Summary box.

Quick Preview button - Quick Preview function compares the first 1000 records and tests whether the data synchronization process will generate error.

Advanced Setting of a Data Synchronization

Mode
Single Direction - Navicat will synchronize data directly from source server to destination server.

Bi-directional - Navicat will synchronize data directly from source server to destination server and vice versa. You can either choose bi-directional insert or bi-directional delete. Update process must be single direction from source to target.

Save synchronization queries to file
- If you enabled this checkbox and clicked on "Start" or "Preview" button, Navicat will save all query statements in a text file.

Commit transaction in case of error
- If you enabled this checkbox and clicked on "Start" button, Navicat will commit the transaction even though there is any error.

Ensure that table structures match
- If you enabled this checkbox and clicked on "Start" button, Navicat will synchronize data only if the table structure of two tables are matched.

Result Window

Summary (the expected changes in the number of rows)- It will show the expected changes in the number of rows.

Log - You can check whether there's any errors.

Deleting a Data Synchronization profile

1. In Navicat, choose Tools > Data Synchronization.
2. Select the profile you want to delete from the pull-down list
3. Click Delete to delete the profile