How to convert MYSQL query into MSSQL query

user3114967 picture user3114967 · Jan 23, 2015 · Viewed 10.4k times · Source

I've 700+ MySQL queries and now trying to create same set of queries in MSSQL.

I want to generate MSSQL query with same MYSQL.Is any way to convert MYSQL query into MSSQL query.

Answer

chridam picture chridam · Jan 23, 2015

From this article by Brian Swan, you can download the SQL Server Migration Assistant for MySQL tool and use it to convert a single MySQL query to a SQL Server query:

  1. Create a Project: All the information you need for downloading SSMA, creating a project and connecting to databases is in steps 1-6 of this blog post.

  2. In the MySQL Metadata Explorer, navigate to the Statements directory of your MySQL database:

enter image description here

  1. Paste the query you want to convert into the query editor window, e.g: SELECT post_title, post_date FROM wp_posts ORDER BY post_date LIMIT 5 OFFSET 5;

enter image description here

  1. Back in the MySQL metadata explorer, right-click Statements and select Convert Schema:

enter image description here

  1. When prompted to save changes, select Yes:

enter image description here

  1. Copy the converted query from the SQL Server query editor window:

enter image description here

Note that SSMA will not successfully translate all MySQL queries, but it does for most. It does not translate some MySQL-specific functions (for example FOUND_ROW()).