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.

Advanced Query Tool

https://www.querytool.com