This topic describes how to use the data warehouse development feature of Data Management (DMS) to periodically migrate data.

Prerequisites

You have permissions to export data from the source database and change data in the destination database. For more information about permissions, see Overview.

Procedure

  1. Create a task flow.
    1. Log on to the DMS console V5.0.
    2. In the top navigation bar, click DTS. In the left-side navigation pane, choose Data Development > Data Warehouse Development.
    3. On the left-side navigation submenu, click the Develop Space icon icon.
    4. In the data warehouse list, find the data warehouse that you want to manage and click the Show icon icon next to the data warehouse to show its details.
    5. Move the pointer over Task Flow and click the Plus icon icon on the right.
    6. In the New Task Flow dialog box, set the Task Flow Name and Description parameters as required.
  2. Create and configure a data migration task.
    1. From the node list on the left side of the task flow editing tab, drag the DTS data migration node to the blank area of the canvas.
    2. Click the DTS data migration node on the canvas.
    3. On the right-side Content tab, select the source database, destination database, and table to be synchronized and specify the synchronization mode and data type.
      Click Edit on the right of the destination table. In the dialog box that appears, configure the filter conditions.
    4. On the right-side Variable Setting tab, set the time variables. For more information about time variables, see Configure time variables.
  3. Enable scheduling.
    1. Click the blank area of the canvas.
    2. Click the Scheduling Settings tab.
    3. Turn on Enable Scheduling.
    4. For more information about scheduling details, see Scheduling properties.
    5. Click Save.

Result

DMS automatically runs the data migration task at the specified time.