Help Center/ Data Replication Service/ Troubleshooting/ Solutions to Failed Check Items/ Conflicts/ Checking Whether the Destination Database Contains Objects with the Same Name As Those in the Source Database
Updated on 2022-09-21 GMT+08:00

Checking Whether the Destination Database Contains Objects with the Same Name As Those in the Source Database

MySQL -> PostgreSQL Synchronization

Table 1 Checking whether the destination database contains objects with the same name as those in the source database

Check Item

Whether destination database contains objects with the same name as those in the source database

Description

The destination database contains objects with the same name as those in the source database. If a table of the same name exists in the destination database, the migration cannot be performed.

Failure Cause and Handling Suggestion

Failure cause: The source and destination database tables cannot have the same names.

Handling suggestions: Check whether the tables with the same names need to be retained. If yes, select another object for synchronization. If no, delete the tables with the same names.

Failure cause: The destination database contains the same table names as those of the synchronization objects.

Handling suggestions: Check whether the tables with the same names need to be retained. If yes, select another object for synchronization. If no, delete the tables with the same names.

Table-Level Synchronization from PostgreSQL to PostgreSQL

Table 2 Checking whether destination database contains objects with the same name as those in the source database

Check Item

Whether destination database contains objects with the same name as those in the source database

Description

The destination database contains objects with the same name as those in the source database If the same object names exist, the migration cannot be performed.

Failure Cause and Handling Suggestion

Failure cause: The destination database contains objects with the same name as those in the source database.

Handling suggestions: Check whether the objects with the same names need to be retained. If yes, select another object for migration. If no, delete the objects with the same names.