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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-06-05 : 08:36:38
|
| Anshuman writes "Basically i need to track changes to my database design. Should the DBA change the length and/or the datatype of a column in a database the change should be logged.I need to record the columns name,datatype,length, precision before and after the change.I know u have a stored proc that gives the name of the table that has changed but i need to record changes in further details." |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-06-05 : 08:40:27
|
| You need to use source control. All table creation scripts are checked into the source control system and no alterations are permitted outside of it. This provides you with all the detail you need on what the tables should look like. If anyone makes unauthorized alterations, you can simply compare it to the legitimate version and change it back, if need be. While it doesn't entirely prevent someone from making unauthorized changes, it does make it easy to undo those changes.There are also tools by Red Gate (http://www.red-gate.com/) that can compare table structures and script the differences, but nothing beats a proper source control system. |
 |
|
|
|
|
|
Tracking changes to columns in a db table.