Methods of copying databases

You can copy databases in different ways both inside an outside of DB2® Change Management Expert. Copying a database involves copying an object or objects, the entire internal structure, and data from the source database to the target database.
You can use several different methods to copy a database, some of which are performed by using DB2 Change Management Expert and some of which are performed by using other DB2 tools. The methods that are supported by DB2 Change Management Expert include: Start of change
  1. Copying a database by using a Deployment Script
  2. Copying a database by using a script file
End of change The method that you choose depends on the database environment and what needs to be copied. In some cases, it might be appropriate to use another DB2 tool, such as DB2 Control Center, DB2 utilities, or the DB2 Command Line Processor, to perform all or part of the database copy. The method that you choose depends on the database environment and on what needs to be copied. The following table compares each method:
Start of change
Table 1. Methods for copying databases and the behavior in DB2 Change Management Expert
Method Description Creates database Copies database structure Copies data
Copying by using a Deployment Script Copy the database by migrating database objects and data. No. Performing a copy using a Deployment Script requires you to create the new database manually. Yes Yes
Manually creating script files Manually create scripts with DB2 Change Management Expert to copy the database. Yes Yes Yes
Copying a database outside of DB2 Change Management Expert Use techniques outside DB2 Change Management Expert to copy the database. Yes Yes Yes
End of change


Feedback

Copyright IBM Corporation 2006, 2007. All Rights Reserved.