EMS logo

Products Navigation

DB Comparer for MySQL

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS DB Comparer for MySQL

On-line Documentation

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 btnMoveScriptFirst btnMoveScriptDown btnMoveScriptUp btnMoveScriptLast 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.

 

Working with Project - Modification Scripts

 

 

Script type

According to the kind of difference between objects in the Source and the Target databases, Data Comparer generates the following modification scripts:

 

iconDifferent 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;

iconOnlyTarget 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;

iconOnlyMaster 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.

 

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:

Viewing Summary Info

Browsing Database Tree

Viewing Objects Definition

Information window

Switching windows