5. Compare databases module

The tool compares two databases and generates a SQL script to make them identical.

Warning

As a result of executing the generated SQL script, the selected databases will have identical structure, but not identical data.

_images/compare_db_module.png

Fig. 5.1 Compare databases module

Source database - the database to the state of which the target database is to be brought to. Target database - the database to which the changes will be applied.

The Attributes block is a list of database elements that need/ do not need to be considered in the comparison.

The Parameters block is a list of conditions that affect comparing databases and forming an SQL script that brings target database structure to state of source database:

  • Check for CREATE/ALTER/DROP - add to SQL script queries for creating/modifying/deleting objects in target database;

  • Ignore comments - consider comments when comparing databases;

  • Ignore calculated fields - consider calculated fields when comparing databases;

  • Ignore fields positions - consider column positions when comparing databases;

  • Ignore spaces - spaces will be ignored when comparing;

  • Ignore PK/FK/UK/CK - consider constraints when comparing databases.

Found differences will be recorded in the Output tab. In SQL tab will be script that brings the structure of the target database to structure of source database.