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 - 2005-04-08 : 12:47:20
|
Hi,Currently we use VSS (MS Visual Source Safe) to track our database changes. Since VSS doesn't integrate with SQL, this is a painful error prone process. ;( Essentially developers have to remember the changes they make and update the VSS project. Is there any logging tool we can run on SQL to track whenever a procedure or table etc has been updated? This is a shot in the dark, but if anyone has any suggestions they would be greatly appreciated.Currently all tables,UDF,sprocs etc are just saved as text files in the VSS database.Nic |
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-04-09 : 11:50:25
|
Seehttp://www.mindsdoor.net/DMO/DMOScriptAllDatabases.htmlIt is for uncontrolled environments and scripts the server/database and saves change history in sourcesafe. If you run it every night takes a few minutes every day (or when you remember to save/review changes.But if you release everything from sourcesafe (to system test then production) you won't have this problem.http://www.mindsdoor.net/SQLServerReleaseControl.htm==========================================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. |
|
|
|
|
|