TFS Database deploy solution

Question

We are trying to come up with a way for our SQL Dev's and DBA's to do all SQL work in MS SQL Management Studio, and work this into a build/deploy process in TFS.

I know RedGate has SQL Source Control, and that lets us keep changes in Management Studio, but how do we incorporate this into a reliable overall build/deploy release workflow?

I don't want to make our SQL team use Visual Studio, their tool of choice is MSSMS.

Looking for some serious help and pointers here, but any help is great.

David Atkinson · Accepted Answer · 2011-05-09 18:16:41Z

1

You'll need to use the SQL Compare Pro and SQL Data Compare Pro command lines to achieve this. An example of how these might be used as part of a build process can be found here:

http://downloads.red-gate.com/HelpPDF/ContinuousIntegrationForDatabasesUsingRedGateSQLTools.pdf

answered May 9, 2011 at 18:16

David Atkinson

5,9382 gold badges30 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

TFS Database deploy solution

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related