How can I set up scheduled daily check in

A SQL Server Management Studio add-in to source control your database in Subversion or Team Foundation Server.

Moderators: Chris Auckland, David Atkinson, sherr, PhilScrace, andy.campbell.smith

How can I set up scheduled daily check in

Postby kulmam92 » Tue Nov 20, 2012 9:51 am

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
kulmam92
 
Posts: 7
Joined: Sat Dec 03, 2011 11:05 am

Postby David Atkinson » Tue Nov 20, 2012 11:46 am

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
David Atkinson
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase


Return to SQL Source Control 3

Who is online

Users browsing this forum: No registered users and 0 guests