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;