怎么把mysql转换mssql_如何将MYSQL查询转换为MSSQL查询

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.

解决方案

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:

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.

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

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;

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

When prompted to save changes, select Yes:

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