Comparing Data

There are three tools in AQT for comparing data:

• comparing results. If you have two Data Display windows open, you can compare the data displayed in these windows. This provides a simple and quick method of comparing different tables. However it has some distinct limitations, for instance it doesn't cope well with rows being inserted / deleted from one of the tables. Once such as difference has been found it will flag all subsequent rows as being different.

  This compare tool also allows you to compare a Data Display window with some saved-results. This allows you to compare a table / query at two different points in time. This can be very useful if you are dealing with time-varying data.

• Data Compare tool. This is a full featured tool for comparing tables or queries. This can handle rows inserted / deleted between the tables. In addition, this can generate a script to resync the contents of the tables.
• Compare Multiple Tables. This can be used to compare a large number of tables, for instance all tables in a schema.