Replicate Microsoft SQL Server Large Value Data Types

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

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

• Limitations of Microsoft SQL Server Large Value Data Types
  There are several limitations for replication of Microsoft SQL Server large value data types.
• Partial Update of Microsoft SQL Server Large Value Data Types
  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.