Datatypes for Microsoft SQL Server Replication

Supported and unsupported datatypes for replicating into and out of Microsoft SQL Server.

Replicating Datatypes into Microsoft SQL Server

These SAP datatypes are supported or unsupported by ECDA 15.0.1 and later for replicating into Microsoft SQL Server.

ECDA Supported and Unsupported SAP Datatypes
Datatype	Supported	Unsupported
SAP	`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.1 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: Replication Agent supports partial update replication for the Microsoft SQL Server max datatypes when the replicate database is Microsoft SQL Server.

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`
	`date`	`filestream`
	`datetime2`	`geography`
	`datetimeoffset`	`geometry`
	`nchar`	`hierarchyid`
	`nvarchar`	`large UDDs`
	`ntext`	`table`
	`varchar(max)` (replicate must be Microsoft SQL Server)	`time`
	`nvarchar(max)` (replicate must be Microsoft SQL Server)	`xml`
	`sql_variant`
	`binary`
	`bit`
	`char`
	`datetime`
	`decimal`
	`float`
	`image`
	`integer`
	`money`
	`numeric`
	`real`
	`smalldatetime`
	`smallint`
	`smallmoney`
	`text`
	`timestamp`
	`tinyint`
	`uniqueidentifier`
	`varbinary`
	`varbinary(max)` (replicate must be Microsoft SQL Server)
	`varchar`