Running the Compare
To run the Compare, click on the Compare button.
- click on Abort to terminate the current compare
- click on Pause to stop the compare after the current compare completes
As the compare runs you will be shown the progress of the compare. In this:
- Read1 - the number of rows read from the Compare table
- Read2 - the number of rows read from the Compare-to table
- OK - the number of rows which are the same
- Not in Tab1 - the number of rows in the Compare-to table which are not in the Compare table
- Not in Tab2 - the number of rows in the Compare table which are not in the Compare table
- Diff - the number of rows which are in both tables but are different
The Compare will create a number of files
These are:
- Report File. This will have a summary of all the compares.
- Compare Report. By default there is one of these created per table compared. They will contain details of the compare and the differences found.
- Resync Script Files. These will be created if you specify that a resync script is to be generated. This is discussed in Generating a Resync Script.
The names and directories for these files are specified on the Options tab.
If you are comparing a lot of tables, a many files can be created. It is recommended that a separate directory is used to hold these files. AQT doesn't delete files from this directory, so you may wish to clean files from this directory on a periodic basis.
Once the Compare has completed
Click on:
- View Report File. This will show you the report file, which has a summary of the compare.
- View Script. This button will appear if you are generating a resync script, and you have selected to use a single script file.
- Run Script. This button will appear in the same circumstances as View Script. This will run the resync script.
When you click on a row in the grid another panel will be displayed. You will have options:
- View Compare Report - this will show you a report of this the errors the load encountered
- View Script File. This button will appear if you are generating a resync script, and you have selected to use a separate script file per table.
- Run Script File. This button will appear in the same circumstances as View Script. This will run the resync script.
You can use the Reset button to return the window to it's original state to rerun the compare.
Table Selection
As you run the compare, the tables are de-selected once they have been compared. This is so that they will not be compared a second time if you resume the compare after it has been paused.
Once the compare has completed, all tables will be de-selected. If you wish to run the compare a second time, click on Select > Select Tables used in last compare (or Ctrl+L).
Alternatively, if you select the option Select > Retain selection after compare run the tables will not be de-selected as the compare is run. In this case you need to be careful not to rerun these compares after a pause.