Replication Server lets you replicate columns that use the Adaptive Server datatypes text, image and rawobject.
When you replicate text, image, and rawobject columns you must specify a compatible replication status for each text, image, and rawobject column in both the replication definition and in Adaptive Server.
You cannot include text, image, or rawobject columns as part of the primary key or as searchable columns.
See the topics under “Managing Replication Definitions” in Replication Server plug-in help for instructions on using Sybase Central to replicate text, image, and rawobject columns.
To replicate text, image, and rawobject columns, follow these steps:
Use create replication definition to create a replication definition for a table that contains text, image, or rawobject columns.
Refer to create replication definition in Chapter 3, “Replication Server Commands” in the Replication Server Reference Manual for complete command syntax and usage guidelines.
Use sp_setreptable to mark the table for replication.
sp_setreptable sets the replication status of text, image, or rawobject columns to always_replicate.
See sp_setreptable in Chapter 5, “Adaptive Server Commands and System Procedures” in the Replication Server Reference Manual for complete syntax and usage guidelines.
If you do not want to replicate some of the text, image, or rawobject columns, use sp_setrepcol to change the replications status of those columns.
See “Changing column status for text, image, or rawobject columns” for instructions.
Use create subscription to make subscriptions for the replication definition and begin replicating the text, image, or rawobject data.
When you execute an update at the primary database,
you can update a text, image,
or rawobject column and a non-text, non-image,
or non-rawobject column--a char column, for
example--with a single command. When those updates are copied to
the replicate database, however, Replicate Server executes two commands,
one for text, image, and rawobject updates
and one for other datatype updates. If you choose to have DSI ignore
certain replication errors, only a portion of the row may be replicated,
which creates an inconsistent replicate table.
