Automated sync using SQL COMPARE

Geert Vanhove

Is it possible to use SQL Compare to automate a sync?
We want to setup a server which is used to test our deployment scripts. On this server, all databases (approx 50) should be refreshed on a daily basis from the pr server. So not only the alter object-scripts should be scheduled, but also the compare process itself

Andy C S

SQL Compare Professional includes command line utilities that can be used in batch files to automate tasks. There are a few examples here:

http://www.red-gate.com/supportcenter/C ... gthecl.htm

You can also use the Comparison SDK to compare programmatically, although this is a separate purchase:

http://www.red-gate.com/supportcenter/C ... g_page.htm