Red Gate forums :: View topic - How can I set up scheduled daily check in
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  | Register 
Go to product documentation
SQL Source Control 3
SQL Source Control 3 forum

How can I set up scheduled daily check in

 Search in SQL Source Control 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message
kulmam92



Joined: 03 Dec 2011
Posts: 7
PostPosted: Tue Nov 20, 2012 9:51 am    Post subject: How can I set up scheduled daily check in Reply with quote
Hi

I'm not sure this is the right tool but I'd like set up daily check in of a DB to SVN. Would you advice me how I can archive this?

Thank you,
Yong
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1082
PostPosted: Tue Nov 20, 2012 11:46 am    Post subject: Reply with quote
You need the sqlcompare.exe, which is SQL Compare Pro's command line. The steps you need are:

1) create an svn working folder
2) run sqlcompare.exe with the following switches

/db1:yourdb /s1:yourserver /scripts2:yourworkingfolder /sync

3) run an svn commit

Use an Agent Job, Windows Scheduler or any other tool that can trigger a batch file periodically. If you plan to install this on a server rather than your desktop, you'll need an Automation License to activate the command line.

David Atkinson
Red Gate
Back to top
View user's profile Send private message Send e-mail
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