If the pending purchase of Sun (owner of MySQL) by Oracle scares you, and you’re looking to get your data out of MySQL before it gets eaten up by that other evil empire, then Microsoft has a tool for you.
They’ve released a test version of their new migration assistant to help database administrators make the change over. There is a version for both SQL 2005 and for SQL 2008 or SQL Azure. The tool provides an assessment of migration efforts as well as automates schema and data migration from MySQL to SQL Server. The tool will migrate any MySQL 4.1, 5.0 or 5.1 database.
Microsoft makes other migration assistants available for Oracle, Access, and a variety of other database formats, so this new tool is not unprecedented. It is however the first time it has made tools for the open-source MySQL available.