DB2® Change Management Expert can
be used to generate some of the script files and to deploy the change commands
that are necessary to copy a database. You can forward engineer the source
database to create a script that will create or recreate all of the physical
database objects.
To copy a database by manually creating script files, complete the
following steps:
- From the Database Explorer view, open a connection to your source
database.
- Select the database and click Generate DDL to
generate a script. You could also add a create database statement
to the top of the script.
- To copy your data, create a script to export the data from the
source database and import the data into the target database. You can deploy
this script from the Data Project Explorer view.
- Select each script, right click and select Run SQL to
copy your database.