Automated sync using SQL COMPARE
Geert Vanhove
Posts: 9
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
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
Comments
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
Red Gate Technical Support Engineer