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.

How can I set up scheduled daily check in

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


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

Postby David Atkinson » Tue Nov 20, 2012 10: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: 1143
Joined: Mon Dec 05, 2005 3:54 pm
Location: Twitter: @dtabase

Return to SQL Source Control Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests