Setting replicate_if_changed

To replicate text, unitext, image, or rawobject columns only when their values change:

  1. Execute the alter replication definition command and change the status of the text, unitext, image, or rawobject columns to replicate_if_changed. Wait for the modified replication definition to arrive at the replicate sites.

  2. Restart RepAgent.