SQL Server to MySQL mapping

AutoSync maps SQL Server column types to the following MySQL column types:


SQL Server column type	MySQL column type
`bit`	`BIT`
`date`	`DATE`
`datetime`	`DATETIME`
`datetime2`	`DATETIME`
`datetimeoffset`	`DATETIME`
`smalldatetime`	`DATETIME`
`time`	`TIME`
`sl_timestamp`	`DATETIME`
`decimal`	`DECIMAL`
`numeric`	`DECIMAL`
`float`	`DOUBLE`
`real`	`DOUBLE`
`int`	`INT`
`integer`	`INT`
`bigint`	`BIGINT`
`smallint`	`SMALLINT`
`tinyint`	`TINYINT UNSIGNED`
`money`	`DECIMAL`
`smallmoney`	`DECIMAL`
`char`	`CHAR`
`hierarchyid`	`VARCHAR`
`nchar`	`CHAR`
`ntext`	`VARCHAR`
`nvarchar`	`VARCHAR`
`text`	`VARCHAR`
`uniqueidentifier`	`VARCHAR`
`varchar`	`VARCHAR`
`binary`	`BLOB`
`image`	`BLOB`
`varbinary`	`BLOB`
`sql_variant`	`VARCHAR`
`table`	`VARCHAR`
`xml`	`VARCHAR`
`geometry`	`VARCHAR`
`geography`	`VARCHAR`