Copying databases by manually creating script files

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:
  1. From the Database Explorer view, open a connection to your source database.
  2. 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.
  3. 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.
  4. Select each script, right click and select Run SQL to copy your database.


Feedback

Copyright IBM Corporation 2006, 2007. All Rights Reserved.