Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nic
Posting Yak Master
209 Posts |
 Posted - 2004-06-28 : 11:59:36
|
| Hi,Our company makes applications (w/ db backends) for a number of different clients. Each client uses a base database that saddly needs to be "customized" from time to time. This means some of the base sprocs need to altered for individual clients. That being said it is difficult to keep track of versioning. I have read that you can use Visual Source Safe for your sprocs. We are planning on moving in this direction (should have done it awhile ago) but I was curious if anyone has any opinions on the subject. Any tricks or tips that you might have learned? Besides VSS, how do others version their sprocs (or dbs on the whole).ThanksNic |
|
|
Kristen
Test
22859 Posts |
Posted - 2004-06-28 : 12:27:04
|
Nigel will be along in a minute, he has some slinky stuff that exports all the database objects (e.g. each night) and stuffs them into SourceSafe.http://www.nigelrivett.net/DMOScriptAllDatabases.htmlWe have a lookup table of User Overrides - if we can find the name of the SProc we are about to install in there we run the "customer specific version" instead.Something likeCREATE TABLE SprocOverride( OurName varchar(100) NOT NULL PRIMARY KEY, ClientName varchar(100)) Kristen |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-06-28 : 12:55:03
|
| I hate to disappoint :).==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2004-06-28 : 15:11:06
|
I don't reckon your SIG is ANSI compliant Nigel.I mean, I can't say WHERE FOO ISN'T NULL can I?!Kristen |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2004-06-28 : 16:16:17
|
| I've used VSS for Stored Procedure versioning for several years. If you already use it for other code, then there'll be no ramp-up time for you. If you've never used it, you'll find it pretty easy to set up. |
|
|
|
|
|
|
sprocs and VSS