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`