Replicate Large-object (LOB) Datatypes

Replication Server supports the replication of Microsoft SQL Server 2005 datatypes varchar(max), nvarchar(max), and varbinary(max). These datatypes can each store up to 2,147,483,647 bytes of data..

Replication Server introduces LOB datatypes as user-defined datatypes (UDDs) in the table-level replication environment. Replication Server also supports database-level replication for new LOB datatypes. The LOB datatypes are directly mapped to text, unitext, and image datatypes.

Mapping of LOB Datatypes to Base Datatypes
New LOB datatype	Base type
`varchar(max)`	`text`
`nvarchar(max)`	`unitext`
`varbinary(max)`	`image`

Limitations of LOB Datatypes
There are several limitations for LOB datatypes.
Partial Update of LOB Datatypes
Partial-update transaction directly writes a character string at a user-defined position of a table column without issuing a delete and replace command, as would happen in a full update.

Parent topic: Manage Replicated Tables