Adaptive Server text, image, and rawobject status: replicate_if_changed
Replication text, image, and rawobject definition status: always_replicate
When RepAgent shuts down because a text, image, or rawobject column has a status of replicate_if_changed at the Adaptive Server database and always_replicate in the replication definition, take the following steps to resolve inconsistencies:
To replicate text, image, or rawobject columns only when their values change:
Execute the alter replication definition command and change the status of the text, image, or rawobject columns to replicate_if_changed. Wait for the modified replication definition to arrive at the replicate sites.
Restart RepAgent.
To always replicate text, image, or rawobject columns:
Stop updates at the primary table.
Execute the alter replication definition command, and change the status of the text, image, or rawobject columns to replicate_if_changed. Wait for the modified replication definition to arrive at the replicate sites.
Restart RepAgent to let transactions with a replicate_if_changed status finish processing.
Execute the sp_setrepcol system procedure at the Adaptive Server and change the status to always_replicate.
Execute alter replication definition and change the status of the text, image, or rawobject columns to always_replicate. Wait for the modified replication definition to be replicated to the replicate sites.
Resume updates to the primary table.
