MySQL and SQL Server data type comparison

My SQL Data type	SQL Server Data types
Yes/no	Bit
Smallint (byte type)	tinyint
Integer (Long integer type)	Int
Real (single-precision floating-point type)	Real
Float (double-precision floating-point type)	Float
Currency	Money
	SmallMoney
Decimal/numeric	Decimal
	Numeric
Date/time	Datetime
	smalldatetime
AutoNumber (incremental)	int (with the defined Identity property)
Text (N)	VARCHAR (n)
	nvarchar (n)
Memo	Text
IMAGE (OLE Object)	Image
Replication ID (also known as a globally unique identifier (GUID))	uniqueidentifier (SQL Server 7.0 only)
Hyperlink	ntext (but the hyperlink is not activated)
(no equivalent data type)	NChar
(no equivalent data type)	varbinary
(no equivalent data type)	User Defined
(no equivalent data type)	smallint
(no equivalent data type)	Timestamp
(no equivalent data type)	Char
	NChar

MySQL and SQL Server data type comparison