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!" ).
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/vi ... hp?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.