this can be used to compare / resync either a single object, or all the objects in a schema
the schemas being compared can be either in the same database, or in two different databases
as with the Object Compare, you can select which objects or properties are to be compared / included in the resync script

Resync Script

AQT will create a comprehensive script for resyncing the two objects or schemas being compared. In the example of comparing two schemas of tables, the resync script will:

create tables which are in the source schema but not the target
optionally, drop tables which are in the target schema but not the source
alter table properties as appropriate
add new columns, alter column properties or drop columns
create or drop indexes, primary keys, foreign keys, aliases, views, triggers, check contraints

Scripting

Object Compare can now be run scripted - eg. run in batch (unattended) mode.

The script statement can be created for you on the Object Compare window - you don't have to type this yourself!

Last reviewed on 14 June 2014