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

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

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: 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.

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

The destination database contains tables with the same name as those in the source database.

Failure cause: The destination database table does not exist and cannot be synchronized.

Handling suggestion: If you do not synchronize the table structure, create the table to be synchronized in the destination database in advance or synchronize the table structure.

Statement for creating a table in the destination database:

CREATE TABLE table_name (column_name data_type);

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

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

Failure cause: The destination database contains the data and indexes of the table to be synchronized.

Handling suggestion: Delete data and indexes from the destination database table. Otherwise, data inconsistency may occur.

• Statement for clearing data in a table:

  TRUNCATE TABLE table_name1;

• Statement for deleting an index:

  DROP INDEX index_name ;

Failure cause: The source database contains encrypted objects.

Handling suggestion: Go back to the object selection page and select database objects that are not encrypted.

Failure cause: Source database names are the same except for letter cases.

Handling suggestion: Change the table name or return to the object selection page and deselect the tables with the same name. Statement for changing the table name:

ALTER TABLE old_table_name RENAME TO new_table_name;

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

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

• If Table structure is selected, the destination database cannot contain objects with the same name as those in the source database.
• If Table structure is not selected, create the corresponding table structure in the destination database in advance.

Failure cause: The destination database table does not exist and cannot be synchronized.

Handling suggestion: If you do not synchronize the table structure, create the table to be synchronized in the destination database in advance or synchronize the table structure.

Statement for creating a table in the destination database:

CREATE TABLE table_name (column_name data_type);

Failure cause: The table to be synchronized has been mapped to the destination database.

Handling suggestion: Return to the Set Synchronization Task page, select the tables that meet the requirements. Alternatively, change the mapping names of the tables to be synchronized.

Failure cause: The table to be synchronized has not been mapped to the destination database.

Handling suggestion: Select Table structure to create a database table, or create the corresponding table structure in the destination database. If the table structure was not missing, check whether the name of the mapped table is correct.

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

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: 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.