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.
To start the Data Synchronization Wizard, click .
In the Data Synchronization Wizard, you can:
If you select a backup as the Target, the Data Synchronization Wizard creates a script to update the database from which that backup was created. You can not modify backups directly with Data Compare for SQL Server.
If you select a backup as the Source, and a database is the Target, Data Compare for SQL Server can synchronize the database with the backup.
If you select a scripts folder as the Target, you can either create a synchronization script to update the database from which that scripts folder was created, or update files in the scripts folder directly.