Red Gate forums :: View topic - Automated sync using SQL COMPARE
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare Previous Versions
SQL Compare Previous Versions forum

Automated sync using SQL COMPARE

Search in SQL Compare Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
Geert Vanhove



Joined: 20 Oct 2011
Posts: 5

PostPosted: Mon Oct 24, 2011 11:21 am    Post subject: Automated sync using SQL COMPARE Reply with quote

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
Back to top
View user's profile Send private message
andy.campbell.smith



Joined: 20 Oct 2011
Posts: 173
Location: Red Gate Software

PostPosted: Wed Oct 26, 2011 1:59 pm    Post subject: Reply with quote

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/Content.aspx?p=SQL%20Compare&c=SQL_Compare%5chelp%5c7.1%5csc_cl_examplesusingthecl.htm

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

http://www.red-gate.com/supportcenter/Content.aspx?p=SQL%20Compare&c=SQL_Comparison_SDK%5chelp%5c7.0%5cSDK_landing_page.htm
_________________
Andy Campbell Smith

Red Gate Technical Support Engineer
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group