Comparison - Overview

Cross-Database Studio Comparison feature allows schema and data comparison between two databases. A user can configure his comparison strategy, followed by the output of detailed reports in XML, HTML formats, as well as direct output on the screen. The comparison can be done for the majority of database objects, including:

Table/View Structure
Table/View Data
Column Properties
Indexes
Primary Keys
Foreign Keys
Selected SQL Request Result
Store Procedures

All the data types including UNICODE and BINARY data types can be compared.

Single object and mass objects comparison are available.

Comparison may be executed immediately or using scheduling.

Comparison is affected by Comparison Options, SQL vendor specifics, Filters, Conversion Rules and Database Connection Objects Settings

Before initiating the Compare process, select "Convert Master" (the check box under the main tool bar). According to Convert Master Cross-Database software will select relevant Conversion Table. For more info about Conversion, see Conversion Rules.

Table/View Structure Comparison – allows obtaining most of the detailed information about table structure differences between two schemas. You can compare:

Column position in a structure
Column Name
Data Type
Data Length
Precision
Scale
Allow Nulls
Default Value

Table/View Data Comparison – allows comparing the data stored in tables/views between two different schemas. It is possible to compare any data types including Unicode and Binary data types.

Primary Keys Comparison - allows obtaining differences for:

Key Name
Key Column Name

Foreign Keys comparison – allows obtaining differences for:

Key name
Primary Table Name
Primary Column Name
Foreign Table Name
Foreign Column Name
Update Rule
Delete Rule

Indexes Comparison - allows obtaining differences for:

Index Name
Column Name
Index Qualifier
Duplicates
Sort Type

User defined SQL Statement Comparison – allows comparing the results of user constructed SQL statements.

Stored Procedure Comparison - allows comparing the contents of the stored procedures as well as the presence/absence of stored procedures in two compared schemas. This option is available only using homogeneous databases on both sides.

Batch (mass) Comparison – a powerful engine that enables running batch comparison sessions, with preliminary configured set of tables or database objects.

XML/HTML file report - allows producing detailed reports of comparison sessions. The reports can be generated in TXT, HTML, XML formats and are easily integrated with other company’s applications.