Setup with a continuous integration server?

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

Setup with a continuous integration server?

Postby nportelli » Tue Dec 06, 2011 8:34 pm

Is this possible? Is the only way to deal with SQL Source control through the UI? No console support? Or would I just need to checkout the SVN and build my own build script to make the DB? Does anyone have this running with Team City or any CI? I'm guessing to do DB versioning I'd need some compare tool as well.

Thank you
nportelli
 
Posts: 2
Joined: Tue Dec 06, 2011 8:31 pm

Postby james.billings » Thu Dec 08, 2011 8:29 pm

SQL Source Control itself only works via the SSMS GUI, however you can achieve a lot (or all) of what you want using SQL Compare which has commandline abilities.

Troy Hunt wrote a blogpost a while back describing some of this and it's well worth a read - see here
james.billings
 
Posts: 1144
Joined: Wed Jun 16, 2010 11:10 am
Location: My desk.

Postby nportelli » Mon Dec 12, 2011 6:09 pm

Well that really sucks. Seems awfully limiting to only have a GUI. Is there any guidance on how to take what is stored in the repo and manually rebuilding the DB?
nportelli
 
Posts: 2
Joined: Tue Dec 06, 2011 8:31 pm

Postby james.billings » Mon Dec 12, 2011 6:15 pm

The next release of SQL Compare will have new commandline options that will enable you to compare directly to revisions in your source control repo - see here for details on this.

You should be able to then use SQL Compare commandline on an automated basis to compare to your current source controlled revision and update. The new version is hopefully due out before christmas.
james.billings
 
Posts: 1144
Joined: Wed Jun 16, 2010 11:10 am
Location: My desk.

Postby David Atkinson » Mon Dec 12, 2011 11:34 pm

Is this useful to you?

http://downloads.red-gate.com/HelpPDF/C ... LTools.pdf

There are some code samples that demonstrate how sqlcompare.exe can be used as part of a continuous integration process.

Kind regards,

David Atkinson
Product Manager
Red Gate Software
David Atkinson
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase


Return to SQL Source Control 2

Who is online

Users browsing this forum: No registered users and 0 guests