Destination Database Same Name Check

Destination database same name check

For synchronization from MySQL to Oracle, check whether there is a database table with the same name 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.

Handling suggestion: To synchronize table structures, delete existing tables from the destination database.

Failure cause: The table structure synchronization is not selected, and there are no tables to be synchronized in the destination database.

Handling suggestion: Select Table structure in the previous step or create the corresponding tables in the destination database.

Failure cause: The source table columns are not a subset of the destination columns.

Handling suggestion: Return to the Set Synchronization Task page, select the tables that meet the requirements. Alternatively, create columns required in the destination table.

Failure cause: 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: 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;