March 24, 2003 at 4:35 am
I think I already know the answer to this. I have been searching for a while to find some way of having intergrated source control in SQL.
Nothing....
Work arounds I have heard of is using MS VSS and having a file per proc / UDF / view etc.
Kepping that in VSS, editing it and then running the script on the DB. Not ideal....
Anybody know of a nice way to accomplish this? Be it a "work around" or a software suite by some really cool company 🙂
Currently, client shouting they was source control. I say not possible with SQL. HELP!!!!!
Cheers,
Crispin
Why don't you try practicing random acts of intelligence and senseless acts of self-control?
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
March 24, 2003 at 12:54 pm
I'd look at Bill Wunder's DDL Archive Utility.
http://home.attbi.com/~bwunder/archive_installation.html
Awesome little utility that I was able to integrate into source safe with very little problems. I have it set up to take a snapshot of our database and log any changes like twice a day (12N,12M) and it works awesome!
Regards,
Chris
March 24, 2003 at 3:20 pm
I took a 2 phased approach. Teach everyone to use VSS and QA, not EM.
Track new objects. When one appears, check that it's in VSS or go yell at someone.
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
March 31, 2003 at 4:41 pm
On top of VSS and QA we use the template capability of SQL 2000 (though you can fake this using text files in earlier versions).
In essence, we have a template file for each type of object (table, view, procedure, etc.) that we would create and use them via QA.
Also, there's no reason that there can ONLY be one object in a source file. If we have a set of objects that are logically grouped together, we create them together in one source script. This is similar to an Oracle package.
$.02
Steve Hendricks
MCSD, MCDBA
AFS Consulting Group
(949) 588-9800 x15
Steve Hendricks
MCSD, MCDBA
Data Matrix
shendricks@afsconsulting.com
(949) 588-9800 x15
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply