How to change the rows that SharePlex considers as the key. (4352577)

It is sometimes necessary to use different columns from the pre-defined ones as keys. In some conditions it may be necessary to instruct SharePlex to consider every column as part of the key.

Updates to numerical key columns can cause violations to unique constraints, in some scenarios, this can be avoided by selecting every column as the key.

The default key can be changed at the table level in the config file. Full details of the syntax are available from the Admin Guide.

The 5.3 manuals have the syntax on page 138 and an example on page 145.