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 is available in Online, Lite, Standard, Professional and Enterprise editions:
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.
SQL conversion features supported by SQLines tool. For more information, also see MySQL to SQL Server Migration Reference.
Converting identifiers:
MySQL | SQL Server |
` (backtick) in Quoted Identifiers | Replaced with [] |
Converting data types:
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 |
COMMENT 'string' | Removed |
ON UPDATE clause for TIMESTAMP columns | Removed |
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 |
Converting functions:
MySQL | SQL Server | |||
1 | CURRENT_TIMESTAMP | CURRENT_TIMESTAMP() | Get current date and time | GETDATE() |