SQL Server to Azure Synapse mapping

AutoSync maps SQL Server data types to the following Azure Synapse column types:

SQL Server data type Azure Synapse column type
bit bit
date date
datetime datetime
datetime2 datetime
datetimeoffset datetimeoffset
smalldatetime datetime
time time
decimal decimal
numeric decimal
float float
real float
int int
integer int
bigint bigint
smallint smallint
tinyint tinyint
money decimal
smallmoney decimal
char char
hierarchyid varchar
nchar nchar
ntext nvarchar
nvarchar nvarchar
text varchar
uniqueidentifier varchar
varchar varchar
binary varchar
image varchar
varbinary varchar
sql_variant varchar
table varchar
xml varchar
geometry varchar
geography varchar