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`