Help Center/ Data Replication Service/ Troubleshooting/ Solutions to Failed Check Items/ Database Parameters/ Whether the Selected Objects Exist in the Destination Database
Updated on 2024-09-25 GMT+08:00

Whether the Selected Objects Exist in the Destination Database

During data synchronization, DRS checks destination database object consistency. If the destination database objects do not meet requirements, data synchronization may fail.

Failure Cause

  • The selected schema does not exist in the destination database.
  • Source database names are the same except for letter cases.
  • The selected table does not exist in the destination database or the table structure is inconsistent with that in the source database.

Handling Suggestion

  • Create the schema in the destination database. Statement for creating a schema:
    CREATE SCHEMA schema_name;
  • Change the table name or return to the object selection page and deselect the tables with the same name.
  • If you choose not to synchronize the table structure, create a table in the destination database and ensure that the table structure is the same as that in the source database