Learn about the datatypes supported and unsupported for replicating into and out of Microsoft SQL Server.
These Sybase datatypes are supported or unsupported by ECDA 15.0.1 and later for replicating into Microsoft SQL Server.
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.1 and later for replicating into Microsoft SQL Server.
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 |
These Microsoft SQL Server datatypes are supported or unsupported by Replication Agent for replicating out of Microsoft SQL Server.
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 |