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. |