|
|
|
|
|
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.sqlThe --aqt datacomp statement generates the resync script file in datacomp_script.sql; this then gets run with the --aqt include statement.