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