Checking Whether There Are Foreign Keys that Are Not Disabled in the Destination Database Table

Whether foreign keys are disabled or tables to be synchronized have foreign keys in the destination database

The destination database has foreign keys that are not disabled. As a result, data synchronization may fail.

Failure Cause: The destination database has foreign keys that are not disabled. As a result, data synchronization may fail.

Handling Suggestion: Use any of the following methods:

1. Change the value of session_replication_role of the destination database user to replica.

set session_replication_role to replica;

2. Deselect these tables from the synchronization objects.

3. Disable or delete foreign keys.

Disabling foreign keys: alter table table_name disable constraint constraint_name;

Deleting foreign keys: alter table table_name drop constraint constraint_name;