refresh_with_referential_integrity

Use this system parameter to indicate whether or not you want the data removed from all the target tables being refreshed before repopulating any of them. This is most useful when there are referential integrity constraints on the tables being refreshed.

This system parameter must set on the source engine and will affect the behaviour of any subscriptions that are using that engine as the source.

Applies to

Source datastores

Values

Set this parameter to one of the following values:

true: Indicates that CDC Replication will first remove all data in reverse of the specified refresh order. When specifying the refresh order, in general parent tables should appear before the referenced child tables. The product will then remove data from the child tables before the parent tables.
false: Indicates that CDC Replication will not first remove all data from your tables and will refresh the tables in the specified order.

Default Setting

false