Selecting 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

There are the following possible steps in the wizard:

  • 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 successful synchronization. If you want the results to be refreshed, select the checkbox next to this option.

Synchronizing 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 synchronization script will deploy the database from the backup.

Synchronizing 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 synchronization. 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 synchronize 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.

Synchronizing 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 a source, and a database is a target, the synchronization script will deploy the database from the snapshot.