Navicat for MySQL allows you to transfer data from one MySQL database to another MySQL database with detailed analytical process. In other words, Navicat provides the ability for data in different databases to be kept up-to-date so that each repository contains the same information. The target database can be on the same server as the source database or on another MySQL server. 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.

Just sample open the data synchronization and use the toolbar below, allowing you to create, save and delete the data synchronization.

Create Data Synchronization

To create a new data synchronization

• Select Tools -> Data Synchronization from the main menu or just select New from the toolbar above.
• Edit data synchronization properties on the appropriate tabs.

To create a new data synchronization with modification as one of the existing data synchronizations

• Select Tools -> Data Synchronization from the main menu
• Select the data synchronization for modifying from the drop-down list.
• Modify data synchronization properties on the appropriate tabs.
• Click Save As.

Edit Data Synchronization

To edit the existing data synchronization

• Select Tools -> Data Synchronization from the main menu.
• Select the data synchronization for modifying from the drop-down list.
• Modify data synchronization properties on the appropriate tabs.

Preview Data Synchronization

To preview a data synchronization before execution

• Create a new data synchronization/open the existing one.
• Click Preview.

Run Data Synchronization

To run a data synchronization

• Create a new data synchronization/open the existing one.
• Click Start.

To run a saved data synchronization profile from the command line (set schedule)

• Create and save the data synchronization profile.
• Start Navicat from command line - Navicat /datasync DataSyncProfileName
  
  

  Note:

  DataSyncProfileName -> name of the saved data synchronization profile

Delete Data Synchronization

To delete a data synchronization

• Select Tools -> Data Synchronization from the main menu.
• Select the data synchronization for droping from the drop-down list.
• Click the Delete from the toolbar.
• Confirm deleting in the dialog window.