How to convert MYSQL query into MSSQL query

问题:

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.

回答1:

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