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.

.. figure:: img/compare_db_module.png

    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.


