Working with Modification Scripts
The Modification Scripts window displays differences between the database objects as a script sequence.
You can view/edit all of the generated scripts with icons denoting their types (ALTER, CREATE, DROP) and the types of objects to be altered/created/dropped, change the script execution order and execute any (or all) of them.
To change the direction of synchronization from Master to Target into Target to Master, 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 select the Find in DB Tree context menu item.
Note: multiple selection of script entries is possible with the Ctrl and Shift keys used.
Script type
According to the kind of difference between objects in the Master and the Target databases, DB Comparer generates the following modification scripts:
ALTER script: if there are different objects with the same name in the Master and the Target databases, script of this type is generated to eliminate the differences;
CREATE/ADD script: if an object exists in the Master 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 Master database, script of this type is generated to drop the object in the Target database.
Note: to change the height of the script entries, use the List of modify scripts group of options available within the Preferences section of the Environment Options dialog.
|
See also: |