Help Center/
Data Replication Service/
Troubleshooting/
Solutions to Failed Check Items/
Database Parameters/
Destination Database Same Name Check
Updated on 2024-11-30 GMT+08:00
Destination Database Same Name Check
Check whether there is a database table with the same name as theh source table in the destination database.
- If Table structure is selected, the destination database cannot contain tables whose names are the same as the source tables to be synchronized.
- If Table structure is not selected, the destination database must have tables that match the source tables, and the table structure must be the same as the selected source table structures.
Failure Cause
- The table structure synchronization is selected, and there are tables to be synchronized in the destination database.
- The table structure synchronization is not selected, and there are no tables to be synchronized in the destination database.
- The source table columns are not a subset of the destination columns.
- Some databases cannot be synchronized because the databases with the same names do not exist in the destination databases. For synchronization tasks, you need to create the corresponding database (user) in the destination database in advance.
Handling Suggestion
- To synchronize table structures, delete existing tables from the destination database.
- Select Table structure in the previous step or create the corresponding tables in the destination database.
- Return to the Set Synchronization Task page, select the tables that meet the requirements. Alternatively, add columns required in the destination table.
- Create these databases or users in the destination database or do not synchronize these databases. Statement for creating a user:
CREATE USER user_name IDENTIFIED BY password;
Parent topic: Database Parameters
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
The system is busy. Please try again later.
For any further questions, feel free to contact us through the chatbot.
Chatbot