Automated sync using SQL COMPARE

Forum for users of SQL Compare schema synchronization utility

Automated sync using SQL COMPARE

Postby Geert Vanhove » Mon Oct 24, 2011 10:21 am

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
Geert Vanhove
Posts: 5
Joined: Thu Oct 20, 2011 2:23 pm

Postby andy.campbell.smith » Wed Oct 26, 2011 12:59 pm

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

You can also use the Comparison SDK to compare programmatically, although this is a separate purchase: ... g_page.htm
Andy Campbell Smith

Red Gate Technical Support Engineer
Posts: 173
Joined: Thu Oct 20, 2011 10:19 am
Location: Red Gate Software

Return to SQL Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests