Altering replication status for text, unitext, image, and rawobject columns  Changing from always_replicate to replicate_if_changed

Chapter 9: Managing Replicated Tables

Changing from replicate_if_changed to always_replicate

To change the replication status of a text, unitext, image, or rawobject column from replicate_if_changed to always_replicate:

  1. Let all transactions with a replicate_if_changed status finish processing.

  2. Use sp_setrepcol to change the status of the column in Adaptive Server to always_replicate.

  3. Use alter replication definition to change the status of the column to always_replicate.




Copyright © 2006. Sybase Inc. All rights reserved. Changing from always_replicate to replicate_if_changed

View this book as PDF