You can use a change plan to migrate structural changes
to from one DB2® for Linux, UNIX, and Windows database
to another. The source of structural changes can also be a DDL script
file or a physical data model.
Overview of migrating changes to a database
New applications or changes to existing applications might
require structural changes to databases. As a database administrator,
you might need to frequently migrate changes that were first made
in the development database environment to the test environment, and
then finally to the production environment.
Migrating database object changes by using the Compare and Migrate wizard
Use the Compare and Migrate wizard
to analyze differences between two databases and migrate the selected
object changes from the source database to the target database. In
addition to a database connection, the source of the changes can also
be a DDL script file or a physical data model.
Scenario: Migrating changes to a development database
As a database administrator you often need to create a
development database that is a subset of the production database.
By working in the development database, you avoid endangering the
production database with untested code.