January 6, 2005 at 9:19 am
We use Source Gear to maintain version control of our web applications. We obviously have several stored procedures for each database. My manager wants to me to maintain version control of the stored procedures and views in each of the databases.
Source Gear does not seem to be set up to do this (or at least I can't figure out how to do it short of creating a text file for each procedure or view!)
How do other people maintain version control of stored procs and views (or is there not really a need to do this?)
Thanks,
Bob
January 6, 2005 at 11:55 am
We use MS Visual Sourcesafe for version control of stored procedures. We don't keep back versions of views.
Greg
Greg
January 6, 2005 at 11:56 am
I've seen a good series of articles on version control in sql2k on this site by Steve Jones. Here's the link, maybe it can help you...
http://www.sqlservercentral.com/columnists/sjones/vcspart1.asp
Eric
January 6, 2005 at 12:30 pm
Imceda Software has a product called Speed IDE that does exactly what you are looking for. You can put any object in your database (sp's, table schema, permissions, views, etc...) under version control. The IDE tool acts as a direct link between your version control system and the sql database. IDE is set to introduce direct support to vault in the next few weeks so I would keep an eye on their website http://www.imceda.com to look for this version.
January 6, 2005 at 11:24 pm
Check out DB Ghost (http://www.dbghost.com) for a complete solution to database versioning and change control. An article was published on this web-site about the methodology used which recieved rave reviews about automated database change management which centers around the use of a source control. It doesn't constrict you to any IDE as it doesn't matter how you develop your source code. http://www.innovartis.co.uk/pdf/Innovartis_An_Automated_Approach_To_Do_Change_Mgt.pdf
January 7, 2005 at 4:17 am
I wrote a vbs script to do this, more for recovery that anything esle. It's posted on this site at http://www.sqlservercentral.com/memberservices/updatescript.asp?Approve=y&scriptid=1151 but you will find a *new improved* 😉 version at http://glossopian.co.uk/pmwiki.php?n=Main.DBtoVSS
HTH
Dave Jackson
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply