This section lists the datatypes supported and unsupported by ECDA 15.0 ESD #3 for replicating into and out of Microsoft SQL Server.
Table 4 lists the Sybase datatypes supported and not supported by ECDA 15.0 ESD #3 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)) |
||
user-defined datatypes (as underlying type) |
Table 5 lists the Microsoft SQL Server datatypes supported and not supported by ECDA 15.0 ESD #3 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 user-defined datatypes |
|
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 |
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.
Table 6 lists the Microsoft SQL Server datatypes that are supported and not supported 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 user-defined datatypes |
|
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 |
