Conflict resolution rule
The conflict resolution rule determines how conflicts between replicated transactions are resolved.
Enterprise Replication supports the following conflict resolution
rules.
Conflict Resolution Rule | Effect |
---|---|
Ignore | Enterprise Replication does not attempt to resolve conflicts. |
Time stamp | The row or transaction with the most recent time stamp is applied. |
SPL routine | Enterprise Replication uses a routine written in SPL (Stored Procedure Language) that you provide to determine which data is applied. |
Time stamp with SPL routine | If the time stamps are identical, Enterprise Replication uses an SPL routine that you provide to resolve the conflict. |
Delete wins | DELETE and INSERT operations win over UPDATE operations; otherwise the row or transaction with the most recent time stamp is applied. |
Always-apply | Enterprise Replication does not attempt to resolve conflicts. You must use the always-apply rule when you replicate TimeSeries data types. |