This parameter controls whether Post returns an out-of-sync message when it detects that a target row already contains the changes that are being replicated from the source. If this condition is met, Post discards the replicated SQL and does not write an out-of-sync message to the Event Log or the errlog.sql log file.
This parameter supports INSERT, UPDATE, and DELETE operations in the following cases:
All values (including the key value) of a replicated INSERT match the existing values of a row in the target.
The key value of an UPDATE matches a row in the target and the existing values in that row match the after (change) values that were replicated from the source.
NOTE: SharePlex will return an out-of-sync message if the target values do not match the replicated after values.
The target row of a DELETE operation does not exist.
By default this parameter is enabled. However, you should still use tools that verify all of the target data, such as the compare command, because out-of-sync values can exist that are not detected by Post.
Default: 1
Range of valid values: 0 (disabled) or 1
Takes effect: Immediately
