How to convert MYSQL query into MSSQL query

Question

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.

Solution

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:

3. 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;

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

5. When prompted to save changes, select Yes:

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

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()).

Comments

[user3114967]

I'm using SQL Yog and there is no Statement option in that. Can you tell me how to do that with SQL Yog.

[user3114967]

Yes I installed SSMA. I created statement and paste one create query in Sql Editor but convert schema option disabled when I right-clicked created statement. How can I enable convert schema??

[chridam]

Did you actually follow the step-by-step installation instructions from this blog post?

[user3114967]

yes, I can create statement,save,create Report but convert schema option disabled.