Running Data Compare in Batch

Compare is run in batch by using the --aqt datacomp statement. This can be run either in a batch file or in the Run SQL window. This is discussed in more detail in Scripting - Datacomp.

The data compare tool can be used to compare and resynchronise tables in unattended mode (such as overnight processing). An example of this is as follows:

--aqt connect,dbs=aqtdemo

--aqt options,stoponerror=yes

--aqt datacomp... etc ...genfile=C:\Program Files\AQT\datacomp_script.sql 

--aqt include,file=C:\Program Files\AQT\datacomp_script.sql

The --aqt datacomp statement generates the resync script file in datacomp_script.sql; this then gets run with the --aqt include statement.

Running Multiple Compare in Batch

If you wish to compare multiple tables then you need to run multiple --aqt datacomp statements. You can use the Generate Text utility to generate these --aqt datacomp statements. The procedure for doing this is described in more detail in Scripting - Datacomp.