Synchronizing Data


Data synchronization can not be rolled back! It may change or delete data in your target database. It is highly recommended to backup target database before synchronizing data.

Synchronizing databases

To start synchronizing data of two databases:

  1. Select the data to synchronize. To do this, select check boxes in the column with check boxes for the tables (or views) you want to synchronize. You may also click a separate table and select check boxes in the column with check boxes on the Only in source, Only in target, and Different tabs for individual records to determine which records to synchronize. Use the check box in the header of the grid to apply settings to all the grid rows.


    Incorrectly mapped objects are displayed with Caution Icon icon instead of check box in the Data Comparison document. Objects with no data to synchronize (with only identical records or with no records at all) are displayed without check boxes. You cannot select them for synchronization.

  2. On the Comparison toolbar, click Synchronize. The Data Synchronization wizard will open.

    Data Synchronization Results

  3. Select whether to backup target database and backup files location. Then select whether to execute a script as a single transaction. You may click the Synchronize button and skip next steps to open the synchronization script in the editor, but this is not recommended if the script is too large. See the Executing Large Scripts topic to know ho to execute script without opening it in the editor. Click Next.

  4. Select where to output synchronization script - open in the editor, save for the future execution, or immediately execute it.

  5. You may either click the Synchronize button to generate the update script or click the Next button to set synchronization options and view the synchronization action plan and synchronization warnings if any exist, and then click the Synchronize button.

  6. Optionally, you can add scripts to be executed before or after data synchronization. For this, switch to the Additional Scripts tab of Data Synchronization Wizard, select Scripts to execute before and/or Scripts to execute after. To type the script right in the wizard, select Use embedded script, and proceed with writing the script in the text box below. To specify a path to a preserved script file, select Use external script, and then click the button to locate the required .sql file.

  7. Optionally, click Save Command Line to create a command line execution file with help of Command Line Execution File Settings Dialog Box.