Online Documentation for SQL Manager for DB2

Create a database copy


In order to create a copy of the whole database or of separate objects you can:

  1. Extract DB objects structure and data into SQL script using the Extract Database Wizard. The result script can be used to copy or restore your database.
  2. Create database backups with the help of the Backup Database Wizard.
  3. Create copies of separate database objects by using the Duplicate Object Wizard.
  4. Create a project on the basis of the existing database using the Project Interaction Wizard. It will serve as a virtual database with objects copied from the real one.