Replication Server lets you replicate columns that use the Adaptive Server datatypes text, unitext, image and rawobject.
When you replicate text, unitext, image, and rawobject columns you must specify a compatible replication status for each text, unitext, image, and rawobject column in both the replication definition and in Adaptive Server.
You cannot include text, unitext, image, or rawobject columns as part of the primary key or as searchable columns.
A unique set of columns must be identified so that text, unitext, image, or rawobject columns replication will only affect one row at the target database. This column or set of columns must be included in the primary key if a replication definition is used.
To replicate text, unitext, image, and rawobject columns, follow these steps:
Use create replication definition to create a replication definition for a table that contains text, unitext, image, or rawobject columns.
Refer to Chapter 3, “Replication Server Commands” in the Replication Server Reference Manual for more information about create replication definition command.
Use sp_setreptable to mark the table for replication.
See sp_setreptable in Chapter 5, “Adaptive Server Commands and System Procedures” in the Replication Server Reference Manual for complete syntax and usage guidelines.
sp_setreptable sets the replication status of text, unitext, image, or rawobject columns to always_replicate.
If you do not want to replicate some of the text, unitext, image, or rawobject columns, use sp_setrepcol to change the replications status of those columns.
See “Changing column status for text, unitext, image, or rawobject columns” for instructions.
Use create subscription to make subscriptions for the replication definition and begin replicating the text, unitext, image, or rawobject data.
When you execute an update at the primary database,
you can update a text, unitext, 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, unitext, 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.
See the Replication Server Heterogeneous Replication Guide and the Replication Server Options documentation for information on non-ASE data servers.
