This is an old revision of the document!
SQLines provides tools and services 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.
We also help convert embedded SQL statements in C/C++ (ODBC, MySQL C API), C#, Java, PowerBuilder, VB/VB.NET, ASP/ASP.NET and Perl/PHP applications.
SQLines tools to help you migrate from MySQL to SQL Server:
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.
SQLines tool is available in Online and Desktop editions:
Online Edition | Desktop Edition | ||
Conversion Features | |||
DDL - Tables and Indexes | |||
Queries, Views and DML Statements | |||
Stored Procedures, Functions and Triggers | |||
Embedded SQL in Applications | |||
Interfaces | |||
GUI | |||
Command Line | n/a | ||
API | n/a | ||
Platforms | |||
Windows 32-bit | Hosted | ||
Linux x86 32-bit | Hosted | ||
Licensing and Support | |||
Technical Support | |||
Price | Purchase |
Try SQLines Online or download a Trial Version.
Technical information on migration from MySQL to Microsoft SQL Server.
Last Update: MySQL 5.6 and Microsoft SQL Server 2012
Converting identifiers:
MySQL | SQL Server | |
Quoted Identifiers | ` (backtick) and " (double quotes) | [ ] and " (double quotes) |
Converting data types:
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) |
Converting functions:
MySQL | SQL Server | |||
1 | CURRENT_TIMESTAMP | CURRENT_TIMESTAMP() | Get current date and time | GETDATE() |
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 |