
Back in the MySQL metadata explorer, right-click Statements and select Convert Schema:ĥ. SELECT post_title, post_date FROM wp_posts ORDER BY post_date LIMIT 5 OFFSET 5 Ĥ. Paste the query you want to convert into the query editor window. In the MySQL Metadata Explorer, navigate to the Statements directory of your MySQL database:ģ. In the remainder of this post (as in the linked-to post), I’ll use the WordPress database as my example database.Ģ. 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.
MICROSOFT WEBMATRIX LINK TO MYSQL DATABASE HOW TO
So, in this post I’ll show you how to use SSMA to convert a single MySQL query to a SQL Server query.ġ. What I didn’t know (and was happy to learn) was that SSMA can also help convert queries. However, for some queries, the conversion is not at all straight forward. For most simple queries, this isn’t terribly difficult. (For a quick tutorial on how to use this tool to migrate a database, see this post.) However, after converting databases, developers still had to convert individual queries from MySQL syntax to SQL Server syntax in order to build SQL Server support into their applications. The tool that helped in doing this was the SQL Server Migration Assistant for MySQL 1.0 (SSMA), which, by most accounts, did a good job at converting databases. One of the challenges that these PHP developers faced was in migrating their MySQL schemas and data to SQL Server. It was also an excellent two-way learning experience…you can read more about the camp here). (As expected, the camp was more than just that. At the JumpIn! Camp that took place a few weeks ago, PHP developers from several countries were invited to come to Redmond and work closely with Microsoft developers to build support for SQL Server and SQL Azure into their applications.
