Datatypes for Microsoft SQL Server Replication

Learn about the datatypes supported and unsupported for replicating into and out of Microsoft SQL Server.

Replicating Datatypes into Microsoft SQL Server

These Sybase datatypes are supported or unsupported by ECDA 15.0 ESD #3 and later for replicating into Microsoft SQL Server.

ECDA Supported and Unsupported Sybase Datatypes
Datatype	Supported	Unsupported
Sybase	`bigint`	`bigdatetime`
	`integer`	`bigtime`
	`smallint`
	`tinyint`
	`decimal`
	`numeric`
	`unsigned bigint`
	`unsigned integer`
	`unsigned smallint`
	`unsigned tinyint`
	`unichar`
	`univarchar`
	`unitext`
	`float`
	`double`
	`real`
	`money`
	`smallmoney`
	`date`
	`time`
	`datetime`
	`smalldatetime`
	`timestamp`
	`char`
	`nchar`
	`varchar`
	`nvarchar`
	`text`
	`binary`
	`varbinary`
	`image`
	`bit`
	`sysname` (same as varchar(30))
	`longsysname` (same as varchar(255))
	`UDDs` (as underlying type)

These Microsoft SQL Server datatypes are supported or unsupported by ECDA 15.0 ESD #3 and later for replicating into Microsoft SQL Server.

ECDA Supported and Unsupported Microsoft SQL Server Datatypes
Datatypes	Supported	Unsupported
Microsoft SQL Server	`bigint`	`cursor`
	`nchar`	`date`
	`nvarchar`	`datetime2`
	`ntext`	`datetimeoffset`
	`varchar(max)` (only for replication not gateway)	`filestream`
	`nvarchar(max)` (only for replication not gateway)	`geography`
	`sql_variant`	`geometry`
	`binary`	`hierarchyid`
	`bit`	`large UDDs`
	`char`	`table`
	`datetime`	`time`
	`decimal`	`xml`
	`float`
	`image`
	`integer`
	`money`
	`numeric`
	`real`
	`smalldatetime`
	`smallint`
	`smallmoney`
	`text`
	`timestamp`
	`tinyint`
	`uniqueidentifier`
	`varbinary`
	`varbinary (max)` (only for replication not gateway)
	`varchar`

Note:

The varbinary(max), varchar(max), nvarchar(max), and sql_variant datatypes are supported only in a replication environment (not for gateway or any other ECDA use) and only to a replicate Microsoft SQL Server database.

Replicating Datatypes out of Microsoft SQL Server

These Microsoft SQL Server datatypes are supported or unsupported by Replication Agent for replicating out of Microsoft SQL Server.

Replication Agent Supported and Unsupported Microsoft SQL Server Datatypes
Datatypes	Supported	Unsupported
Microsoft SQL Server	`bigint`	`cursor`
	`nchar`	`date`
	`nvarchar`	`datetime2`
	`ntext`	`datetimeoffset`
	`varchar(max)` (replicate must be Microsoft SQL Server)	`filestream`
	`nvarchar(max)` (replicate must be Microsoft SQL Server)	`geography`
	`sql_variant`	`geometry`
	`binary`	`hierarchyid`
	`bit`	`large UDDs`
	`char`	`table`
	`datetime`	`time`
	`decimal`	`xml`
	`float`
	`image`
	`integer`
	`money`
	`numeric`
	`real`
	`smalldatetime`
	`smallint`
	`smallmoney`
	`text`
	`timestamp`
	`tinyint`
	`uniqueidentifier`
	`varbinary`
	`varbinary(max)` (replicate must be Microsoft SQL Server)
	`varchar`