October 3, 2002 at 7:15 am
I was wondering if anyone can advice on how to version control stored procedures?
October 3, 2002 at 7:32 am
You can script stored procedures and store them in Visual SourceSafe aka VSS (which is free with Visual Studio). When you have all the stored procedures for a particular build, you can label them all so that you can retrieve based on build, not just on latest version.
I believe Steve Jones is preparing a VSS integration article for SQL Server.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
October 3, 2002 at 8:53 am
We use VSS extensively. It may be a freebie but it's nice and simple and does a bussineslike job.
One thing I would reccomend if you do use it is to ensure that you have Keywords Enabled and that you use the $History: $ keyword in a comment block at the top of your scripts. It provides an excellent header containg all the version history
I have found it is possible to please all of the people all of the time if you do exactly what they want. Harold Macmillan 1961
I have found it is possible to please all of the people all of the time if you do exactly what they want. Harold Macmillan 1961
October 3, 2002 at 9:53 am
VSS isn't a freebie AFAIK. But it is included with Visual Studio and it fits nicely in a MS shop. CVS is a free tool and there is a windows port.
You can read my articles at:
http://www.sqlservercentral.com/columnists/sjones/vcspart1.asp
http://www.sqlservercentral.com/columnists/sjones/vcspart2.asp
http://www.sqlservercentral.com/columnists/sjones/vcspart3.asp
http://www.sqlservercentral.com/columnists/sjones/vcspart4.asp
Steve Jones
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply