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
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?
- Posts: 7
- Joined: Sat Dec 03, 2011 11:05 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.
- 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 1 guest