Help Center/ Data Replication Service/ Troubleshooting/ Solutions to Failed Check Items/ Database Parameters/ Checking Whether the Source Table Replication Attribute Is Correct
Updated on 2024-11-30 GMT+08:00
View PDF
Share

Checking Whether the Source Table Replication Attribute Is Correct

The replica identity attribute of the source database table must be FULL. If the source database contains tables whose replication attribute is not Full, incremental synchronization may fail.

Failure Cause

  • The selected source database table contains the primary key column, but the replication attribute is not FULL.
  • The source database contains tables whose replication attribute is not Full. As a result, incremental synchronization may fail.

Handling Suggestion

Change the replication attribute of the table to FULL. Run the following statement in the source database:

ALTER TABLE table_name REPLICA IDENTITY FULL;
Parent topic: Database Parameters