question

Steve Jones - Editor avatar image
Steve Jones - Editor asked

Source control for T-SQL

Can I integrate source control systems, like SourceSafe or PVCS, with SSMS?

t-sqldevelopmentsource-control
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Laerte Junior avatar image
Laerte Junior answered

Yes..and works fine !!! Actually I do it out of work including, with my scripts at home too..Using SourceSafe

Managing Solutions with Source Control

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Simon Hartcher avatar image
Simon Hartcher answered

Yes of course. The company I work for keeps all our source code (including t-sql) in Subversion (or SVN for short).

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Håkan Winther avatar image
Håkan Winther answered

Yes, and if you want to use TeamFoundationServer (I like this a lot more than SourceSafe), you can add Visual Studio Team System 2008 Team Foundation Server MSSCCI Provider.

Download it from here http://www.microsoft.com/downloads/

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Stephanie avatar image
Stephanie answered

Red Gate is currently working on a source control solution, which would allow you to source control your database schema right from SQL Server Managment Studio without ever having to script out the objects, http://www.red-gate.com/products/SQL_Source_Control.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.