Data Transfer Service
- Release Notes and Announcements
- Announcements
- Product Introduction
- Specification Description
- Preparations
- Network Preparation
- Interworking Between local IDC and Tencent Cloud
- Adding DTS IP Addresses to the Allowlist of the Corresponding Databases
- DTS Service Permission Preparation
- Data Migration
- Migration to MySQL Series
- Migrating to MySQL
- Migrating to MariaDB
- Migrating to TDSQL-C for MySQL
- Migrating to TDSQL MySQL
- Migrating to TDSQL TDStore
- Advanced Operations for MySQL Series Migration
- Processing for MySQL Series Pre-Check Failure
- Migrating to PostgreSQL
- Processing for PostgreSQL Series Pre-Check Failure
- Migrating to MongoDB
- Migration from MongoDB to MongoDB
- Fix for Verification Failure
- MongoDB Data Consistency Verification
- Migrating to SQL Server
- Migration from SQL Server to TencentDB for SQL Server
- Pre-Validation Failure Handling
- Migrating to TencentDB for Redis
- Migration from Redis to Redis
- Fix for Verification Failure
- Migrating to KeeWiDB
- Migration from Redis to KeeWiDB
- Task Management
- Data Sync
- Sync to MySQL series
- Sync to MySQL
- Sync to MariaDB
- Sync to TDSQL-C for MySQL
- Sync to TDSQL for MySQL
- Sync from TDSQL for MySQL to TDSQL for MySQL
- Sync to TDSQL TDStore
- MySQL Series Advanced Sync Operations
- MySQL series Pre Validation Failed Processing
- Synchronize to PostgreSQL
- PostgreSQL Pre Validation does not Pass Processing
- Synchronize to Kafka
- MySQL/MariaDB/Percona/TDSQL-C MySQL Sync to Kafka
- TDSQL MySQL Sync to Kafka
- Task Management
- Data Subscription (Kafka Edition)
- MySQL series Data Subscription
- Consuming MySQL Data
- Advanced Subscription Operations
- Fix for Verification Failure
- Data Subscription for TDSQL PostgreSQL
- Fix for Verification Failure
- MongoDB Data Subscription
- Fix for Verification Failure
- Task Management
- Consumption Management
- Fix for Verification Failure
- Monitoring and Alarms
- Configuring Metric Alarms and Event Alarms via the Console
- Practical Tutorial
- FAQs
- Error Handling
- API Documentation
- Making API Requests
- (NewDTS) Data Migration APIs
- Data Sync APIs
- Data Consistency Check APIs
- (NewDTS) Data Subscription APIs
- DTS API 2018-03-30
- Data Subscription APIs
- Making API Requests
- DTS APIs
- Service Agreement
DocumentationData Transfer ServiceData SyncSync to MySQL seriesMySQL series Pre Validation Failed ProcessingTarget Database Content Conflict Check
Target Database Content Conflict Check
Last updated: 2024-07-08 17:48:28
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.
Option 1: Use database/table mapping.
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)
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
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
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.
Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No