Comparing Data

In This Chapter

There are two 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.