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 |
|
harshal_in
Aged Yak Warrior
633 Posts |
 Posted - 2004-01-13 : 04:19:20
|
| Hi all!,I am supposed to version the databases.Currently I am taking the scripts of the database and versioning them using VSS.I wanted to know what is the general practice of versioning the databases.regards,harshal.He is a fool for five minutes who asks , but who does not ask remains a fool for life! |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
|
|
harshal_in
Aged Yak Warrior
633 Posts |
Posted - 2004-01-13 : 05:35:50
|
quote:
Originally posted by Merkin
NR wrote a great article on exactly this http://www.nigelrivett.net/SQLServerReleaseControl.htmDamian
that is real big one. I'll go through it, thanks for directing.regards,harshal.He is a fool for five minutes who asks , but who does not ask remains a fool for life! |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-01-13 : 06:47:06
|
| You can also script the dtabases for SourceSafe via a scheduled job http://www.nigelrivett.net/DMOScriptAllDatabases.htmlHaven't done the bit to automatically add the updates to SourceSafe yet but it's not difficult to do it manually.==========================================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. |
|
|
|
harshal_in
Aged Yak Warrior
633 Posts |
Posted - 2004-01-13 : 06:55:45
|
quote:
Originally posted by nr
You can also script the dtabases for SourceSafe via a scheduled job http://www.nigelrivett.net/DMOScriptAllDatabases.htmlHaven't done the bit to automatically add the updates to SourceSafe yet but it's not difficult to do it manually.==========================================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.
currently the versioning was done only during the release the whole database script is added to the VSS and is updated only during the next release.But this method looks very interesting.I think I'll have to discuss this with PM and give it a try.He is a fool for five minutes who asks , but who does not ask remains a fool for life! |
|
|
|
|
|
|
Database Versioning