Automated sync using SQL COMPARE

Forum for users of SQL Compare schema synchronization utility

Moderators: JonathanWatts, Chris Auckland, David Atkinson

Automated sync using SQL COMPARE

Postby Geert Vanhove » Mon Oct 24, 2011 11: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 3:23 pm

Postby andy.campbell.smith » Wed Oct 26, 2011 1: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:

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
Andy Campbell Smith

Red Gate Technical Support Engineer
andy.campbell.smith
 
Posts: 173
Joined: Thu Oct 20, 2011 11: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