Wednesday, March 21, 2012

How to use SQL Server Management Studio to save existing SP to source safe?

Wiith SQL Server Management Studio(SQL Server 2005 tools), you can create a project and solution and connect to SourceSafe, then create SQL scripts.These scripts will be able to be checked in/out SourceSafe.

Question is: For existing SQL Server 2000 database, how can I add all existing Stored Procedure to this solution/project and then be able to use sourcesafe to maintain the SP code history?

What I would do is create a database solution/project for each instance in VS2005, script out the objects from the database server and add them to the solution, add the solution to your source control.

No comments:

Post a Comment