Red Gate forums :: View topic - TeamCity PlugIn - is this the way to go?
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare 10
SQL Compare 10 forum

TeamCity PlugIn - is this the way to go?

Search in SQL Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
Spud



Joined: 21 Mar 2013
Posts: 16
Location: United Kingdom

PostPosted: Thu Mar 21, 2013 3:52 pm    Post subject: TeamCity PlugIn - is this the way to go? Reply with quote

Hi, apologies if this question is a little "fluffy", but resources as to exactly what the TeamCity plugin does seem to be hard to find, so here goes..

We currently have

a) A nice TeamCity build creating setup kits for our .net check-ins
b) Our database Changes in redgate SQL Source Control.
c) Database change scripts created manually using another 3rd party tool (I hear you say "boo!" Very Happy ).
d) Scripts deployed automatically via our own software

So far so good, but the next step is to get SQL scripts output by our TeamCity build, by purchasing SQL Compare, and *presumably* the TeamCity plug in.

Is this what the TeamCity plugin can be used for, or does the plugin update the target database(s) as part of the build? (NB I want the output of the build to be SQL scripts / something else that we can rollout via our software)

It sounds like you cannot include migration scripts using the plugin (http://www.red-gate.com/messageboard/viewtopic.php?p=60327) so is the plugin going to do what we want, or should I be using SQL Compare from the command line as part of the build.
I'm assuming the plugin doesn't do everything the command line does, but cannot find any comparisons.

I hope my ramblings make sense. Thanks in advance.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6641

PostPosted: Mon Mar 25, 2013 4:17 pm    Post subject: Reply with quote

Thanks for your question. The TeamCity plugin's main purpose is to create NuGet packages for deployment using automated deployment tools like TeamCity or Deployment Manager. You don't need the add-in to turn a live database into a series of scripts; you can still use SQL Compare for that.

If this fits better into your existing CI framework, you can still use the SQL Compare command-line. The only thing you will need is a licence (automation licence) to run the command-line on a server other than the one where you normally use SQL Compare.

When the TeamCity plugin documentation refers to "migration scripts", that term specifically denotes custom scripts you use to replace the scripts that SQL Compare automatically creates. The reason why you would do this is, for instance, if you changed a column from allowing nulls to NOT NULL and you needed to insert a line to update all existing null data to prevent the schema update from failing.
Back to top
View user's profile Send private message
Spud



Joined: 21 Mar 2013
Posts: 16
Location: United Kingdom

PostPosted: Thu Mar 28, 2013 1:32 pm    Post subject: Reply with quote

Thanks for your reply Brian.
For us it looks like the command line is the way to go, even though I currently have a few outstanding issues with it.

We want the build to output scripts, and it looks like the only way to get the TC Plug in to create scripts is via the deployment manager, so we're plugging away without the TC Plug-In.
Back to top
View user's profile Send private message
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