Support for Large-Object Datatypes

With Replication Manager 15.1, you can manage large-object (LOB) datatypes that are defined in your replication environment.

Replication Manager supports Microsoft SQL Server LOB datatypes of varchar(max), nvarchar(max), and varbinary(max). However, if a column contains any of these LOB datatypes, the column cannot be a primary key, or marked as searchable.

The following changes have been made in the Replication Manager GUI:

If you have LOB datatypes in your replication environment, the Replication Definition Datatype and Published Datatype lists in the Create Replication Definition dialog box display LOB.
On the Columns tab in the Add New Table Replication Definition dialog, when you select a column that contains varchar(max), nvarchar(max), and varbinary(max) datatypes, the Primary Key and Searchable options are disabled.

See the Replication Server Administration Guide Volume 1 for detailed information about working with LOB datatypes.