Help Center/ Data Replication Service/ Troubleshooting/ Solutions to Failed Check Items/ Database Parameters/ Checking Whether Tables Structures Are Consistent
Updated on 2024-09-25 GMT+08:00
View PDF
Share

Checking Whether Tables Structures Are Consistent

If you select only data for synchronization, DRS checks the consistency of table structures between the source and destination databases.

Failure Cause

  • The number of columns in the destination table is less than that in the source table.
  • If the source and destination databases are different, the column names in the source table are converted to lowercase letters for comparison with those in the destination table.
  • Column names contain spaces or special characters.

Handling Suggestion

Return to the Set Synchronization Task page, select the tables that meet the requirements. Alternatively, modify columns required in the destination table. Ensure that the source table columns are a subset of the destination columns.

Parent topic: Database Parameters