You can follow the general procedure in this topic to create and manage a task in data integration mode.

Background information

  • Use cases

    The data integration mode of DTS allows you to schedule data migration tasks to run on a regular basis. This mode is typically used for recurring migrations in a large data warehouse system.

  • Supported targets and sources

    The supported targets and sources are the same as for data migration mode. For more information about supported data sources and targets, see Supported sources and targets

Data integration procedure

You can complete the following higher level steps to create and manage a data integration task.

Step Description
1. Set up a networking environment Before you use DTS for data integration, you must make your source or target database reachable by DTS servers over the network. For more information, see Set up a network environment for replication.
2. Create a data integration task Create a data integration task in the DTS console. For detailed steps, see Create a data integration task.
3. View the progress of the data migration You can view the status of a scheduled data migration in the DTS console. You can check the progress in the same way as for a task in data migration mode. For detailed steps, see View the progress of a data migration task..
4. View historical tasks You can view details of data migration tasks that were previously scheduled by the data integration task. For more information, see View the occurrences of a data integration task.
5. Stop the data integration task or change the schedule If you no longer require scheduled data migrations, stop the data integration task in the DTS console. You can also change the schedule of a data integration task instead. For more information, see Modify the settings of a scheduling policy.