Compare Objects

The Compare Objects is part of the Extended Edition of AQT.

Options for the Compare

The Object Compare can be used to compare tables and their related objects, such as indexes, primary keys, foreign keys.

• You can compare a single table, or all tables in a schema
• You can specify whether to compare just the table definition, or also indexes, foreign keys etc
• The "Parameters for" box shows you what parameters of the object will be compared. You can change these if you do not want to compare a particular parameter.
• You can compare tables even if they are in databases of different types. The example here is for comparing a table in SQL Server to a table in DB2.

The result from the Compare is displayed in three displays. This makes it very easy to see the results of the compare.

• The top grid has one line per table compared, with a summary of whether the compare was successful.
• The bottom-left grid has one line per column in the table or (when comparing indexes, etc), one line per index
• The bottom-right grid has the details of the column/index compare. The value of each parameter being compared is displayed.
• When comparing tables from different databases (as per this example), AQT copes with differences in data types between different databases.