Online Documentation for SQL Manager for DB2
CLP Move
CLP Move Data Wizard allows you to move data between DB2 databases with the CLP move utility used.
The CLP move utility, when used in the EXPORT/IMPORT/LOAD mode, facilitates the movement of large numbers of tables between DB2 databases located on workstations. The COPY mode (available in DB2 9.5 and higher) allows you to copy schema templates (with or without data) from a source database to a target database or move an entire schema from a source database to a target database.
To run the wizard, select the Services | 
CLP Move main menu item, or right-click a database alias in the DB Explorer and select the Database Operations | CLP Move context menu item.
- Specifying DB name and connection parameters
- Specifying EXPORT destination
- Specifying COPY destination
- Setting IMPORT/LOAD options
- Selecting objects to export/copy
- Specifying COPY options
- Moving data
|
Availability: |
|
|
Full version (for Windows) |
Yes |
|
Lite version (for Windows) |
No |
|
Note: To compare all features of the Full and the Lite versions of SQL Manager, refer to the Feature Matrix page. |
|
|
See also: |
