While a task is running in Data Transmission Service (DTS), you can use the console to check the status of each module and stay updated on the task's progress.
Procedure
This topic uses a data synchronization task as an example.
-
Go to the Data Synchronization Tasks page.
-
Log on to the DMS console.
-
In the top navigation bar, click Data + AI.
-
In the left-side navigation pane, choose .
Note-
Operations may vary based on the mode and layout of the DMS console. For more information, see Simple mode console and Customize DMS console layout and style.
-
You can also go to the Data Synchronization Tasks page of the new DTS console.
-
-
Click the ID of the target instance.
-
In the left-side navigation pane, click Task Management, and then clear the Hide Completed Modules checkbox.
-
Follow the steps below for your task type.
Note-
This example describes the procedure for viewing schema and full data tasks. The actual UI may vary depending on the task type, source database type, and destination database type.
-
If an error occurs while an instance is running, an Error Message is generated on the Basic Information tab of the module where the error occurred. If your instance is in the China (Qingdao), China (Zhangjiakou), China (Hohhot), China (Ulanqab), China (Chengdu), or China (Hong Kong) region, Qwen also provides a potential solution below the Error Message. This solution is for reference only.
-
View schema task details.
-
In the Progress section, click the Schema Migration 1 module.
-
Click the Task Details tab.
-
Click a schema object type tab, such as Table, to view the task details for that object type. On the Task Details tab, you can switch between the Table, View, Function, and Procedure subtabs to view different object types. The table lists the Object name, Status, Source database, Destination database, and Actions columns. Use this information to confirm whether the schema migration for each object was successful.
Note-
You can also filter objects by name by using the search feature.
-
In the Actions column for an object, click View Statements or View Foreign Keys to view its creation syntax.
-
In the Actions column for an object, click Schema Revision to modify its creation syntax. Then, click Save and Submit to apply the changes.
-
-
-
View full data task details.
-
In the Progress section, click the Full Data Migration module.
-
Click the Full Data Migration Progress tab.
-
View the task details for each object, or filter objects by name by using the search feature. The table displays information for each synchronized object, including its Object name, Status, Source database, Destination database, Estimated total, and Completed count.
NoteFor tables that encounter an error during the full data task, you can click Skip in the Actions column if your business needs allow.
-
-