Replication Server and Replication Agent impose the following constraints on Microsoft SQL Server datatypes:
If you use a version of Replication Server prior to version 12.0, you must set the value of the Replication Agent use_rssd configuration parameter to true to avoid problems with the Microsoft SQL Server smallint and tinyint datatypes.
If you use a version of Replication Server prior to version 12.5, the following size restrictions are imposed on Microsoft SQL Server datatypes:
Microsoft SQL Server char and varchar datatypes that contain more than 255 bytes are truncated to 255 bytes.
Microsoft SQL Server nchar and nvarchar multibyte character datatypes are replicated as char or varchar single-byte datatypes.
As of Replication Server version 12.5 and later, these
datatype size restrictions are no longer in effect.
