This is an old revision of the document!


SQLines Tool - MySQL to SQL Server Migration

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

SQLines Features and Licensing

SQLines is available in Online, Lite, Standard, Professional and Enterprise editions:

Online Lite Standard Professional Enterprise
Lines of Code Limitation
DDL Statements Unlimited Unlimited Unlimited Unlimited Unlimited
DML Statements, Queries and Views 3,000 10,000 30,000 Unlimited Unlimited
Procedural SQL 3,000 n/a 10,000 30,000 Unlimited
Conversion Features
DDL - Tables and Indexes
DML Statements
Built-in SQL Functions
Queries and Views
Stored Procedures
User-Defined Functions
Triggers
Interfaces
Command Line n/a
API n/a
Platforms
Windows 32-bit Hosted
Linux x86 32-bit Hosted
Licensing and Support
Technical Support
Price Free $135 $375 $975 $1735

Try SQLines Online or download a Trial Version (no registration required).

If any you have any questions or need any assistance, please contact us at support@sqlines.com.

Conversion Features

SQL conversion features supported by SQLines tool. For more information, also see MySQL to SQL Server Migration Reference.

Language Elements

SQL language elements:

MySQL SQL Server
Single line comment -- Supported, no changes required

Identifiers

Converting identifiers:

MySQL SQL Server
` (backtick) in Quoted Identifiers Replaced with []

Data Types

Converting data types:

MySQL SQL Server
1 DATE Date (year, month and day) DATE Since SQL Server 2008
2 DATETIME Date and time DATETIME
3 DECIMAL(p,s) Fixed-point number DECIMAL(p,s)
4 INT, INTEGER 32-bit integer INT, INTEGER
5 LONGTEXT 4 GB Character large object (LOB) VARCHAR(max)
6 MEDIUMTEXT 16 MB Character large object (LOB) VARCHAR(max)
7 TEXT 64 KB Character large object (LOB) VARCHAR(max)
8 TINYINT 8-bit integer TINYINT
9 TIMESTAMP(p) Auto-updated datetime DATETIME
10 VARCHAR(n) Variable-length character string VARCHAR(n)

Data Type Attributes:

MySQL SQL Server
Display width for integers INT(d) Removed
UNSIGNED CHECK (col_name > 0)
AUTO_INCREMENT IDENTITY
COLLATE collate_name Removed
CHARACTER SET charset_name Removed
ON UPDATE clause for TIMESTAMP columns Removed

Data Definition Statements

Converting DDL statements and clauses:

MySQL SQL Server
IF NOT EXISTS clause in CREATE TABLE Removed
AUTO_INCREMENT column property Changed to IDENTITY
AUTO_INCREMENT = start initial value Removed
Storage ENGINE = engine_type clause Removed
DEFAULT CHARSET | CHARACTER SET = character_set table option Removed
COLLATE = collate_name table option Removed

Built-in SQL Functions

Converting functions:

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