How can we help you today? How can we help you today?

Automating Compare & Synchronise

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.
EACC_NZ
0

Comments

1 comment

Sort by
  • Brian Donahue
    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.
    Brian Donahue
    0

Add comment

Please sign in to leave a comment.