The SQL Server Migration Assistant (SSMA) team announced today the availability of the migration assistant for MySQL! (Yes, it supports SQL Server Express.) You can…
Actually, the team announced the release of three other migration assistants: SSMA for Access, SSMA for Oracle, and SSMA for Sybase (all v4.2). But, I’m most excited about the MySQL assistant, not only because it is a v1.0 release, but because I think it will come in handy for lots of people…I’ve seen the “How can I easily migrate a MySQL database to SQL Server?” question come up occasionally on forums that I watch. The bonus that this release adds is that it can also migrate a MySQL database directly to the SQL Azure cloud.
I had a chance to play with the SQL Server Migration Assistant for MySQL when it was in beta a few months ago. It did a great job then of migrating a simple MySQL database, but the team has added lots of functionality since the first beta release (including support for migrating stored procedures). The download includes a help file with documentation that will give you an understanding of other features the team has added. What I’ll do here is walk you through the “Hello World”-type usage of the assistant. I’ll use SSMA to move a MySQL WordPress database to SQL Server.
Note: I’m just showing how to migrate a WordPress database as an example. If you actually want to run WordPress on SQL Server, see this post by Zach Owens: WordPress on Microsoft.
1. Download the SQL Server Migration Assistant. After the ins