Q
Problem solve Get help with specific problems with your technologies, process and projects.

Making efficient schema changes

From a DBA's perspective, what is the most efficient way to make schema changes? Drop and reload the environment, DDL specific changes, other? What are the pros and cons to each approach and why would our DBA recommend the first option?
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 .VO7aaqqaAFk.0@/search390>discussion forums.

This was last published in October 2004

Dig Deeper on IBM DB2 management

PRO+

Content

Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchAWS

SearchContentManagement

SearchOracle

SearchSAP

SearchSQLServer

Close