Once the comparison is finished, you are now ready to start the database synchronization.
By default all objects that are found to be different are automatically included in the synchronization script. You can however easily change which objects should or should not be included by checking or un-checking the Synchronization checkbox in the comparison grid (see Selecting Objects).
You can generate a synchronization script to change either the left database on the right database. There are three ways to start the script generation:
- Ribbon - in the "Review Compare" tab of the ribbon there are two big buttons in the middle under the grouping "Generate Script". Each button is labeled with the name of the server + name of the database for which the script will be generated.
- Action Links on the right panel - are listed under the label "Generate the script for". Clicking on the [server].[database] link generates the synchronization script that will make that database the same as the other one.
- Context menu - when you right click on the comparison results grid a context menu will pop up. The context menu allows you to access the comparison options and trigger the generation of the synchronization script in addition of other context relevant actions.
