Automating Compare & Synchronise

EACC_NZEACC_NZ Posts: 17
Hi, We're running SQL Data Compare 5 V5.2.0.40 and we are wanting to know how to completely automate the process of compare and synchronisation, with a view to hourly updates? Because of the business rules stating that the sending database is the authorative source, we do not need to verify the data prior to update.
Unfortunately SQL and Replication updates are not allowed by the application Vendor, hence the need for an alternative.
Regars

Colin

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Hi,

    You are allowed to use the command-line utility, sqldatacompare.exe, when you have a professional edition licence for SQL Data Compare. This can be run from Windows Scheduled tasks to synchronize data on a schedule.

    I would definitely test this out first, however, because Data Compare needs to compare the whole of the selected tables (unless you can specify a WHERE clause) and this process can delay data synchronization by an unfeasably long time.
Sign In or Register to comment.