tencent cloud

Feedback

Target Database Content Conflict Check

Last updated: 2024-07-08 19:41:52

    Check Details

    The target instance cannot contain objects with the same name as those in the source database. If a conflict causes an error, troubleshoot by using any of the following methods.
    If an entire instance is migrated, 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 contain conflicted advanced objects. If a conflict causes an error, you need to delete the conflicted objects.

    Troubleshooting

    Using database/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 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 and 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 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 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.
    Contact Us

    Contact our sales team or business advisors to help your business.

    Technical Support

    Open a ticket if you're looking for further assistance. Our Ticket is 7x24 avaliable.

    7x24 Phone Support