You can change the replication key of a replicate from
the primary key, a unique index or constraint, or the ERKEY shadow
columns to another unique index or constraint on your table.
Procedure
To change the replication key of a replicate:
- Define a new replicate by running the cdr define
replicate command. Include the --key option
to specify the new replication key. Do not include the --erkey option.
- Start the new replicate by running the cdr start
replicate command.
- Stop the original replicate by running the cdr
stop replicate command.
- Delete the original replicate by running the cdr
delete replicate command.