Select synchronization output

After you have selected the objects for synchronization, you can use the Schema Synchronization Wizard to create the synchronization script. To open the synchronization wizard, click Synchronization arrow.

Selecting synchronization output

The possible steps in the wizard are as follows:

  • Open the synchronization script in the internal editor

If this option is selected, the script for database synchronization will be opened in the internal editor of the Schema Compare tool. You will be able to execute it by clicking the Execute button on the toolbar menu.

Internal script editor

  • Save the script to a file

If you can save the script locally on your PC, select this option and specify a path to a folder you want to save the script to. If you want to open the script in the internal editor after saving click to select the checkbox next to this option.

  • Execute the script directly against the target database

Select this option, if you want to execute the script without reviewing it.

Schema Compare can also refresh comparison results after the successful deployment of object changes. If you want the results to be refreshed, select the checkbox next to this option.

Synchronize backups

If you select a backup as a target, the synchronization wizard creates a script to update the database from which the backup was created. You can not modify backups directly.

If a backup is selected as a source, and a database is a target, the deployment script will deploy the database from the backup.

Synchronize scripts folders

When a scripts folder is the target, Update the scripts folder option appears on the Output tab of the Schema Synchronization Wizard.

Update the scripts folder

Select this option, if you want to synchronize a database and a script folder directly without reviewing a script.

You can also choose to open the folder containing the output files and refresh comparison results after successful deployment of schema changes. Click to select the checkbox next to these options if you want these actions to be performed.

Clicking the Scripts Folder Structure button allows you to specify a structure for scripts folder and file name templates. This mapping configuration will be used by schema comparison and source control by default.

Scripts Folder Structure

Note

If you select a backup or a snapshot as a target, the option to deploy schema changes using Schema Compare is not available. Instead, Schema Synchronization Wizard creates a script to modify the data source from which the snapshot or backup was created.

Synchronize snapshots

When synchronizing a database as a source and a snapshot as a target, Schema Synchronization Wizard overwrites a snapshot as a result.

Overwrite a snapshot

When a snapshot is the source, and a database is the target, the synchronization script will deploy the database from the snapshot.

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