Generating a Resync Script

You can generate a script to resync the contents of the tables. The options for doing this are on the Options tab.

As with Data Compare, you have the option generating the script to:

• make the Compare tables the same as the Compare-To tables.
• make the Compare-To tables the same as the Compare tables.

Resync Script File Name

You have the option of a creating either

• a single script file with the changes to all the tables or
• a separate script file per table.

To have a separate resync file per table, de-select the Use a single Script file? checkbox. AQT will change the script file name to include <tname> in the file name.

When the compare is run, AQT will substitute the table name where <tname> has been coded. You can also specify <schema> to include the schema in the file name.

Seperate Resync Files for Updates / Inserts / Deletes

You the option Generate upd/insert/del as seperate files to have updates / inserts / deletes statements to be written to separate files.

This will be done in addition to the "main" resync file with all the changes.

Report or Script File

When the compare finishes, you can automatically be shown the Report and/or Resync script files. These are specified on the Show Report file and Show Script file options.

• No means you will not be shown the file when the compare completes
• Prompt means you will be prompted to see the file when the compare completes
• Yes means you will be shown the file when the compare completes.

Alternatively, once the Compare has been run:

• If you have a single resync script, you will get a button at the bottom of the window View Script
• If you have a separate resync script file per table, you can view the resync script by:
  • click on the entry in the grid
  • click on View > Script File

Note that this option will only be enabled if a resync script has been created for that table. This will only happen if AQT has found some differences between the tables.

Running the Resync Script File

When the compare has finished, you can automatically run the script file to resync the contents of the tables. This is particularly useful when running the compare in batch / unattended mode to resync the two schemas.

The option Run Script file specifies whether the script is to be automatically run once the compare has completed. This takes values No / Prompt / Yes as described earlier. Note:

• when running the compare as a batch script, Prompt will be interpretted as No. You must specify this as Yes to run have the script run.
• if you Pause the compare, the script will not be run.

Alternatively, once the Compare has been run:

• If you have a single resync script, you will get a button at the bottom of the window Run Script
• If you have a separate resync script file per table, you can run the resync script by:
  • click on the entry in the grid
  • click on Run Script File on the panel that is displayed

Start with new Script File

On the main compare page there is an option Start with new Script file. This is used when you are using the single script file option.

By default this option is checked, so AQT will clear the contents of the script file before the compare is run. If you Pause the compare, this option will be de-selected, so AQT will append to the script file when the compare is resumed.