|
The most efficient way to make database schema changes is to use a product like BMC Software's Change Manager. With such a product, all you have to do is specify what changes need to be made using the intuitive menu-driven interface. Then, the product will analyze the requests and build a script to make each change in the most effective way. If it can be done with an ALTER, Change Manager will build the script for that. If it requires a DROP and reCREATE, then Change Manager will build that script taking care of all the intermediate work such as saving security setting, unloading and reloading data, etc.
More information on Change Manager can be found here.
Editor's note: Craig Mullins is director of technology planning at BMC Software Inc.
Editor's note: Do you agree with this expert's response? If you have more to share, post it in one of our discussion forums.
|
