April 9, 2003 at 11:40 am
Hi ,
How can i use Visual source safe for SQl server stored procedures??
We use to stored the sp's a text file and store it in VSS and when ever there is a modification we use to update thse text files.
Is there way we do in VB for SQL server too??
Thanks,
MK
April 9, 2003 at 12:07 pm
I don't think you could use VSS with SQL because the objects are not save into independent files. You could create a job to periodically scripts the Sp and check that they remain the same with the ones you have is source safe.
April 9, 2003 at 2:03 pm
Do a simple search on "Visual Source safe" and you'll find numerous articles on Change management and source code management. eg:
http://www.sqlservercentral.com/columnists/ckempster/changemanagement.asp
I remember seeing a few scripts in Scripts section that does the similar. Check out the scripts section.
April 9, 2003 at 2:45 pm
Bill Wunder has a great freeware program that does what you want. Look for "Bill Wunder's DDL Archive Utility" under Products.
Jay Madren
Jay Madren
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply