Automating Compare & Synchronise
EACC_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.
Unfortunately SQL and Replication updates are not allowed by the application Vendor, hence the need for an alternative.
Regars
Colin
Colin
Comments
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.