SQL Server to Redshift mapping
AutoSync maps SQL Server data types to the following Redshift column types:
SQL Server data type | Redshift column type |
---|---|
bit |
boolean |
date |
date |
datetime |
timestamp |
datetime2 |
timestamp |
datetimeoffset |
timestamptz |
smalldatetime |
timestamp |
time |
time |
decimal |
decimal |
numeric |
decimal |
float |
double precision |
real |
double precision |
int |
integer |
integer |
integer |
bigint |
bigint |
smallint |
smallint |
tinyint |
smallint |
money |
decimal |
smallmoney |
decimal |
char |
char |
hierarchyid |
varchar |
nchar |
varchar |
ntext |
varchar |
nvarchar |
varchar |
text |
varchar |
uniqueidentifier |
varchar |
varchar |
varchar |
binary |
varbyte |
image |
varbyte |
varbinary |
varbyte |
sql_variant |
varchar |
table |
varchar |
xml |
varchar |
geometry |
varchar |
geography |
varchar |