- Documentation
Database Transmission Service
Data migration
Pausing a migration task
Data migration
Pausing a migration task
Pausing a migration task
During data migration, if you encounter peak business hours and measures such as modifying the link specification or adjusting the full migration rate still can not meet the requirements, you may choose to pause the migration task and resume it during off-peak business hours. This topic describes how to pause a migration task on the Database Transmission Service (DTS) console.
Prerequisites
Precautions
- If source and target instances are in different regions, you need to pause the task at the destination.
- After pausing, the migration status changes to “Paused”. You can continue the migration by starting the migration task. For details, refer to Starting a migration task.
- When a task is paused for more than 7 days, the task can not be resumed due to expired logs required by the source database. To avoid potential irrecoverable task issues, it is recommended that the pause duration does not exceed 24 hours.
- When a normally running migration task is paused, the current session (i.e., the database session between the DTS server and the target database) is not immediately terminated. Simultaneously, if the transactions being executed by the current session are not committed, the resources occupied by these transactions - such as row locks and table locks - will not be released. As a result, other sessions may be blocked when requesting these resources, which could potentially impact the existing performance of the database. If a task remains paused for an extended period (exceeding the inactive session timeout parameter), the session will be terminated and transactions will be rolled back. When pausing a task, it is recommended to confirm that DTS is not migrating large transactions, as this may otherwise lead to degraded database performance.
Pause a specified task
- In the upper-left corner of the top menu bar, select the project and region.
- In the left navigation bar, click Data migration.
- On the Migration task list page, select More operations > Pause in the upper-right corner of the target task in Migration task list.
- In the Pause selected migration task? dialog box, click Pause.
Batch pause tasks
- In the upper-left corner of the top menu bar, select the project and region.
- In the left navigation bar, click Data migration.
- On the Migration task list page, select the migration tasks to pause, then click Batch pause in the bottom menu bar.
- In the Pause task dialog box, click OK.
- Confirm the tasks to be paused in the Pause task dialog box. To exclude any tasks, click Remove in the Actions column to delete them.
Related APIs
Last updated: 2026.02.03 16:01:45