March 5, 2009 at 6:45 am
hi,
will it be possible to add sps to source safe and will it can be used like the c# files with source control..
can anyone give a detailed steps regarding this
George
March 5, 2009 at 7:28 am
Basically to use SourceSafe with your DB you need to script out any DB objects you want to put in SourceSafe, add them to a SourceSafe project, and then discipline yourself to go to SourceSafe to check out the scripts, make you modifications, run the script against the database, and then check in the modified script. It is not as automatic as working with C#/VB.Net and SourceSafe.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
March 5, 2009 at 7:47 am
It is not automatic but it saved our project when our development SQL Server failed twice. All our .bak and stored procedures are in VSS so both times we were up and running in a very short time. Note if your application is also using SSRS make sure to prefix the SSRS stored procedures with Reports.
I did not add how, there are two ways for the stored procedure .sql files either through server explorer or each developer save their stored procedures in their development folder as .sql files and right click and import into VSS. And our team lead adds the .bak files.
Kind regards,
Gift Peddie
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply