tencent cloud

Check Details

MySQL/MariaDB/Percona/TDSQL-C for MySQL/TDSQL for MySQL check requirements

• The target instance cannot have objects with the same name as those in the source database. If a conflict causes an error, you can fix it in one of the following methods:
  • Option 1: Use database/table mapping.
  • Option 2: Rename or delete objects with the same name in the target database.
  • Option 3: Remove objects with the same name from the migration objects.
• During entire instance migration, the target instance must be empty. If a conflict causes an error, you need to delete the instance content.
• If advanced objects are selected, the target database cannot have conflicting advanced objects. If a conflict causes an error, you need to delete the conflicting objects.

PostgreSQL check requirements

• The target instance cannot have objects with the same name as those in the source database.

• During entire instance migration, the target instance must be empty. If a conflict causes an error, you need to delete the instance content.

MongoDB check requirements

The target instance can have tables with the same name as those in the source database, but they must be empty tables. If a conflict causes an error, you can fix it in one of the following methods:

• Option 1: Delete tables with the same name in the target database or clear their data.
• Option 2: Remove objects with the same name from the migration objects.

SQL Server check requirements

The target instance cannot have databases with the same name as those in the source database; otherwise, an error will be reported.

If an error is reported, you need to delete or rename databases with the same name from the target database.

Redis check requirements

The target instance must be empty; otherwise, an error will be reported.

If an error is reported, delete the content in the target instance and restart the verification task.

Troubleshooting

Using table mapping (for MySQL/MariaDB/Percona/TDSQL-C for MySQL/TDSQL for MySQL only)

You can use the DTS table mapping feature to map the names of the objects to be migrated with the same name to other names in the target database.

1. Log in to the DTS console, select the corresponding migration task, and click More > Modify in the Operation column.
2. In Selected Object on the right, hover over an object to be modified, click the displayed Edit icon, and rename the object.
   
3. Run the verification task again.

Modifying objects with the same name in target database

Log in to the target database, rename or delete the objects with the same name as the migration objects.

Removing objects with the same name from migration objects

Modify the migration task configuration to remove the objects with the same name from the migration objects. The removed objects cannot be migrated.

1. Log in to the DTS console, select the corresponding migration task, and click More > Modify in the Operation column.
2. Remove the objects with the same name from the migration objects.
3. Run the verification task again.

Deleting the target database content

Log in to the target database, delete the objects with the same name as those in the source database or the entire database, and run the verification task again.