Working with Modification Scripts
The Modification Scripts window displays differences between the database objects as a row of modification scripts.
You can view\edit any generated scripts. There is an icon for each script denoting its script type (ALTER, CREATE, DROP) and corresponding object type.
To change the direction of synchronization from Source to Target to Target to Source, switch between the corresponding tabs of the Modification scripts window.
Use the toolbar buttons or items of the context menu to manage the script order. Moreover, the context menu allows you to specify which of the scripts should be executed and edit scripts using SQL Script Editor. You can also double-click a script to open it in SQL Script Editor.
Upon selecting an entry within the Modification scripts window, the corresponding element can be selected in the database tree: right-click the required script and use Find in DB Tree context menu item.
Note: multiple selection of script entries is possible with the Ctrl and Shift keys used.
According to the kind of difference between objects in the Source and the Target databases, Data Comparer generates the following modification scripts:
ALTER script: if there are different objects with the same name in the Source and the Target databases, script of this type is generated to eliminate the differences;
CREATE/ADD script: if an object exists in the Source database and it does not exist in the Target database, script of this type is generated to create the object in the Target database;
DROP script: if an object exists in the Target database and it does not exist in the Source database, script of this type is generated to drop the object in the Target database.
Note: Synchronization is always performed in one direction (i.e. in one database) depending on the tab selected.