Advanced Query Tool

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.
Compare options

Compare Results

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.
Compare results

Another Example

The example below compares all tables in two different Oracle schemas. The top grid shows the tables and the results of the compare. For table DEPARTMENTS, the Table attributes are different - the lower grid shows how these attributes compare.

Load Mapping
  Go Home Go to Top

Last reviewed on 18 May 2011   

Copyright 2002-2011 Cardett Associates Ltd. All rights reserved.