MySQL to Microsoft SQL Server Migration

SQLines provides tools to help you transfer data, convert database schema (DDL), views, stored procedures and functions, triggers, queries, embedded SQL statements and SQL scripts from MySQL to Microsoft SQL Server.

Databases:

MySQL 8.x and 5.x
Microsoft SQL Server 2019, 2017, 2016, 2014, 2012, 2008 and 2005

MySQL to SQL Server Migration Tools

SQLines tools to help you migrate from MySQL to SQL Server:

SQLines SQL Converter Tool

SQLines SQL Converter tool allows you to convert database schema (DDL), queries and DML statements, views, stored procedures, functions and triggers from MySQL to SQL Server.

SQLines tool converts SQL scripts and standalone SQL statements. To migrate data and database schema from a MySQL database use SQLines Data tool.

MySQL to Microsoft SQL Server Migration Reference

Technical information on migration from MySQL to Microsoft SQL Server.

Last Update: MySQL 5.6 and Microsoft SQL Server 2012

Identifiers

Converting identifiers:

	MySQL	SQL Server
Quoted Identifiers	` (backtick) and " (double quotes)	[ ] and " (double quotes)

Data Types

Converting data types:

	MySQL		SQL Server
1	BIGINT	64-bit integer	BIGINT
2	BINARY(n)	Fixed-length byte string, 1 ⇐ n ⇐ 255	BINARY(n)
3	BIT(n)	Fixed-length bit string, 1 ⇐ n ⇐ 64	BINARY(n/8)
4	BLOB(n)	Binary large object, ⇐ 64K	VARBINARY(max)
5	BOOLEAN, BOOL	0 or 1 value; NULL is not allowed	BIT
6	CHAR(n), CHARACTER(n)	Fixed-length string, 1 ⇐ n ⇐ 255	CHAR(n), CHARACTER(n)
7	CHARACTER VARYING(n)	Variable-length string, 1 ⇐ n ⇐ 65535	CHARACTER VARYING(n)
8	DATE	Date (year, month and day)	DATE	Since SQL Server 2008
9	DATETIME(p)	Date and time data with fraction	DATETIME2(p)
10	DECIMAL(p,s), DEC(p,s)	Fixed-point number	DECIMAL(p,s), DEC(p,s)
11	DOUBLE [PRECISION]	Double-precision floating-point number	FLOAT
12	FIXED(p,s)	Fixed-point number	DECIMAL(p,s)
13	FLOAT(p)	Floating-point number	FLOAT
14	FLOAT4(p)	Floating-point number	FLOAT
15	FLOAT8	Double-precision floating-point number	BINARY_DOUBLE
16	INT, INTEGER	32-bit integer	INT, INTEGER
17	INT1	8-bit integer	SMALLINT
18	INT2	16-bit integer	SMALLINT
19	INT3	24-bit integer	INT
20	INT4	32-bit integer	INT
21	INT8	64-bit integer	BIGINT
22	LONGBLOB	Binary large object, ⇐ 4G	VARBINARY(max)
23	LONGTEXT	Character large object, ⇐ 4G	VARCHAR(max)
24	LONG VARBINARY	Binary large object, ⇐ 16M	VARBINARY(max)
25	LONG, LONG VARCHAR	Character large object, ⇐ 16M	VARCHAR(max)
26	MEDIUMBLOB	Binary large object, ⇐ 16M	VARBINARY(max)
27	MEDIUMINT	24-bit integer	INT
28	MEDIUMTEXT	Character large object, ⇐ 16M	VARCHAR(max)
29	MIDDLEINT	24-bit integer	INT
30	NCHAR(n)	Fixed-length UTF-8 string, 1 ⇐ n ⇐ 255	NCHAR(n)
31	NVARCHAR(n)	Varying-length UTF-8 string, 1 ⇐ n ⇐ 65535	NVARCHAR(n)
32	NUMERIC(p,s)	Fixed-point number	NUMERIC(p,s)
33	REAL	Double-precision floating-point number	DOUBLE PRECISION
34	SERIAL	64-bit autoincrementing integer	NUMERIC(20)
35	SMALLINT	16-bit integer	SMALLINT
36	TEXT	Character large object, ⇐ 64K	VARCHAR(max)
37	TIME(p)	Time (Hour, minute, second and fraction)	TIME(p)
38	TIMESTAMP(p)	Auto-updated datetime	DATETIME2(p)
39	TINYBLOB	Binary data, ⇐ 255 bytes	VARBINARY(255)
40	TINYINT	8-bit integer	SMALLINT
41	TINYTEXT	Character data, ⇐ 255 bytes	VARCHAR(255)
42	VARBINARY(n)	Variable-length byte string, 1 ⇐ n ⇐ 65535	VARBINARY(n)
43	VARCHAR(n)	Variable-length string, 1 ⇐ n ⇐ 65535	VARCHAR(n)
44	YEAR[(2 \| 4)]	Year in 2-digit or 4-digit format	NUMERIC(4)

Data Type Attributes:

MySQL	SQL Server
Display width for integers INT(d)	Not supported
UNSIGNED	CHECK (col_name > 0)
AUTO_INCREMENT	IDENTITY
COLLATE collate_name
CHARACTER SET charset_name
COMMENT 'string'
ON UPDATE clause for TIMESTAMP columns	Not supported
BINARY(0)	BINARY(1)

Built-in SQL Functions

Converting functions:

	MySQL			SQL Server
1	CURRENT_TIMESTAMP	CURRENT_TIMESTAMP()	Get current date and time	GETDATE()

CREATE PROCEDURE Statement

Converting stored procedures from MySQL to SQL Server:

	MySQL		SQL Server
1	CREATE PROCEDURE name		CREATE PROCEDURE name
2	DEFINER = user		Removed
3	IN \| OUT \| INOUT param datatype(len)	Parameter definition	@param datatype(len) OUT \| OUTPUT
4	No AS keyword before outer BEGIN END block		AS keyword required
5	User-defined delimiter at the end		GO