Red Gate forums :: View topic - Setup with a continuous integration server?
Return to www.red-gate.com RSS Feed Available

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

Setup with a continuous integration server?

Search in SQL Source Control 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
nportelli



Joined: 06 Dec 2011
Posts: 2

PostPosted: Tue Dec 06, 2011 8:34 pm    Post subject: Setup with a continuous integration server? Reply with quote

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
Back to top
View user's profile Send private message
james.billings



Joined: 16 Jun 2010
Posts: 1144
Location: My desk.

PostPosted: Thu Dec 08, 2011 8:29 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
nportelli



Joined: 06 Dec 2011
Posts: 2

PostPosted: Mon Dec 12, 2011 6:09 pm    Post subject: Reply with quote

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?
Back to top
View user's profile Send private message
james.billings



Joined: 16 Jun 2010
Posts: 1144
Location: My desk.

PostPosted: Mon Dec 12, 2011 6:15 pm    Post subject: Reply with quote

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



Joined: 05 Dec 2005
Posts: 1122
Location: Twitter: @dtabase

PostPosted: Mon Dec 12, 2011 11:34 pm    Post subject: Reply with quote

Is this useful to you?

http://downloads.red-gate.com/HelpPDF/ContinuousIntegrationForDatabasesUsingRedGateSQLTools.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
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