Constraint and replication

When you use constraints, ensure that the constraints you add at the target server are not more restrictive than the constraints at the source server. Discrepancies between constraints at the source and target servers can cause some rows to fail to be replicated.

If your replicated tables that have referential integrity constraints between them, synchronization the data through the replicate set. For replicate sets, Enterprise Replication synchronizes tables in an order that preserves referential integrity constraints (for example, child tables are synchronized after parent tables).

When you synchronize data, rows that fail to be repaired due to discrepancies between constraints are recorded in the ATS and RIS files.