Changing the replication key of a replicate

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:
  1. 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.
  2. Start the new replicate by running the cdr start replicate command.
  3. Stop the original replicate by running the cdr stop replicate command.
  4. Delete the original replicate by running the cdr delete replicate command.