Migrating data by using the Migrate Data wizard

Use the Migrate Data wizard to migrate data from one table to another in DB2® for Linux, UNIX, and Windows databases.

Before you begin

The Database Administration feature must be installed and a connection must exist for the database that you want to migrate data to.

Procedure

  1. Display any objects in the database that you want to migrate data to in the Object List.
    1. In the Administration Explorer view, find and expand the database.
    2. Click any data object type folder, such as the Tables folder. The objects are displayed in the Object List.
    3. Click anywhere in the Object List to make the view active.
  2. From the main menu, click Migrate > Migrate Data. The Migrate Data wizard starts.
  3. Complete the steps in the wizard. The wizard guides you through specifying the following information:
    1. The source connection for the data.

      You must identify a connection for the database that you want to migrate the data from. You can select an existing connection or create a new one.

    2. The source and target table pairs from which to unload and reload data.

      You must identify the pairs of tables from which to save data and into which to load the saved data. You can select the source and target schema to map multiple tables at once, or use the Add New Entry icon to add tables one at a time.

    The Review and Deploy dialog opens.
  4. Ensure that the Save data check box is selected.
  5. Optional: Specify a directory into which to save the data. If the target and source databases are not on the same system and have a shared file system, specify a location on the shared file system.
  6. Optional: Click Column Mapping to change how the data from the unloaded columns is mapped to the columns that are being reloaded. A dialog opens where you can change the unloaded to reloaded column mapping for each table.
  7. Run the generated commands. In the Review and Deploy dialog, click Run and then click Finish.

Results

New rows are added to the target tables. The status of running the commands is displayed in the SQL Results view.


Feedback