The destination database permission check fails during the precheck phase during DTS data migration

Updated at: 2023-08-30 03:55

Problem description

When Alibaba Cloud Data Transmission Service Service DTS checks whether the account permissions of the destination database meet the migration requirements during data migration, the "Destination Database Permission Check" check item precheck fails.

Cause

The account of the destination database does not have sufficient permissions to perform data migration tasks.

Solution

To ensure the smooth execution of the data migration task, DTS checks the permissions of the account of the destination database configured in the data migration task during the precheck. This ensures that the account has sufficient permissions to perform the data migration task. Permissions are required for different types of databases and data migration types. For more information, see Overview of data migration scenarios If the Migration Failed message appears during schema migration or full data migration, you can use the online fix feature of DTS to manually fix the task. For more information, see Fix a failed data migration task.

References

  • On this page (1, T)
  • Problem description
  • Cause
  • Solution
  • References
Feedback