Materializing text, unitext, image, and rawobject data

In general, you can use any materialization method for subscriptions for tables with columns that use the text, unitext, image, or rawobject datatypes. If you use atomic or nonatomic materialization, the Replication Server managing the replicate database selects all of the subscription data into a subscription materialization queue.

If you want to materialize text, unitext, image, or rawobject data, you can use automatic materialization only if the size of your data row is less than 32K. Otherwise, you must use bulk materialization.

If you are materializing many large data rows, make sure that the Replication Server has sufficient queue space for the data before you create the subscription. For tables with a large volume of text, unitext, image, and rawobject data, you may need to add temporary partitions to the Replication Server to complete the materialization.