Replicate text, unitext, image, and rawobject Columns

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.

    See Replication Server Reference Manual > Replication Server Commands > create replication definition.

  • Use sp_setreptable to mark the table for replication.

    SeeReplication Server Reference Manual > Adaptive Server Commands and System Procedures > sp_setreptable.

• 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.

• Use create subscription to make subscriptions for the replication definition and begin replicating the text, unitext, image, or rawobject data.

See the Replication Server Heterogeneous Replication Guide and the Replication Server Options documentation for information on non-ASE data servers.

• Replicating Large Objects to Non-ASE Servers Using Enterprise Connect Direct Access
  Replication Server replicates large objects such as text and image to non-ASE servers by passing a writetext command to Enterprise Connect Direct Access (ECDA), where it is converted to an update statement.
• Guidelines for Creating a text, unitext, image, or rawobject Replication Definition
  There are several guidelines to follow when you create a table replication definition for text, unitext, image, or rawobject columns.
• Mark Tables with text, unitext, image, or rawobject Columns
  Use sp_setreptable to set the initial replication status for text, unitext, image, and rawobject columns in Adaptive Server when you mark the table for replication.
• Change Column Status for text, unitext, image, or rawobject Columns
  Use sp_setrepcol to adjust the replication status for text, unitext, image, or rawobject columns.
• Alter Replication Status for text, unitext, image, or rawobject Columns
  When you replicate text, unitext, image, and rawobject columns you must specify a compatible replication status for each column in both the replication definition and in Adaptive Server.
• Subscription Issues for replicate_if_changed Status
  If you create subscriptions for replication definitions with text, unitext, image, or rawobject columns that have the status replicate_if_changed, use either bulk materialization or materializing text, unitext, image, or rawobject data.
• Function Strings for Replicating text, unitext, and image Data
  You must create rsdatarow_for_writetext, rs_get_textptr, rs_textptr_init, and rs_writetext function strings for each text, unitext, or image column, if you replicate columns with text, unitext, or image datatypes to a non-Adaptive Server database.