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 t1919605.html#multiTask2785.

Procedure

  1. Create a task flow.
    1. Log on to the DMS console V5.0.
      Note To use the previous version of the DMS console, click the Return to old version icon icon in the lower-right corner of the page. For more information, see Switch to the previous version of the DMS console.
    2. In the top navigation bar, click the DTS tab. In the left-side navigation pane of the tab, choose Data Development > Data Warehouse Development.
      Note If you are using the previous version of the DMS console, move the pointer over the More icon in the top navigation bar and choose Data Factory > 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 Table 1.
    5. Click Save.

Result

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