Create custom pre- and post-execution scripts

After you have selected the options to manage synchronization script output and set synchronization options, you can create custom scripts that will be run before or after schema synchronization.

To set additional scripts:

1. To open the synchronization wizard, click Synchronization arrow Synchronize objects to the target database.

2. In the Schema Synchronization Wizard that opens, switch to the Additional Scripts tab to add pre and/or post scripts.

3. To insert the script to be executed before schema synchronization, select the Scripts to execute before check box and then select either of the following options:

  • Use embedded script: Enter a script you want to execute in the text field.
  • Use external script: Click More options icon More options to specify the path to the file that stores the script. If you want to add the USE database_name clause, select the Include USE < database_name > option.

For example, you need to create partition tables in the target database. However, there are no files and filegroups in that database. Schema Compare works only with database-level objects, all server-level objects will not be included in the comparison and, thus, in the synchronization script. In this case, you can run the script before schema synchronization.

Insert scripts to be used before schema synchronization

4. To insert the script to be executed after schema synchronization, select the Scripts to execute after check box and then select either of the following options:

  • Use embedded script: Type a script, which you want to execute, in the text field.
  • Use external script: Click More options icon More options to import the previously created script. If you want to add the USE database_name clause, select the Include USE < database_name > option.

5. Optional: Switch to the Summary tab and verify the synchronization options.

6. After you’ve configured the synchronization options, click Synchronize.