Select synchronization output

After you have selected the objects to include in the synchronization, use the Data Synchronization Wizard to create the SQL script that will synchronize the Source and the Target.

Use the Data Synchronization Wizard

To start the Data Synchronization Wizard, click Start synchronization button.

In the Data Synchronization Wizard, you can:

  • Open the synchronization script in the internal browser for reviewing.
  • Save the script to a file and specify a path to it.
  • Execute the script directly against the target database. You can select to refresh the comparison results after deployment.

Data Synchronization Wizard

Tip

When you perform a database comparison and save the synchronization script using the default file name, which includes the source and target database names, re-synchronizing the same databases with the same file-saving option may overwrite the existing script. To avoid this, enable the Add Timestamp option when saving the script. This appends a timestamp to the file name, ensuring each synchronization script remains distinct.

If you click Save Command Line, the Command Line Wizard will get opened.