MySQL to SQLServer 2008 Express [redux]

  • Article

Last week, the SQLServer 2008 Express team released a download with the SQL Server Management Studio. A few weeks ago, I blogged how to export/import the .sql from one system to another.

Having installed the Management Studio, I noticed that I could import data into my new SQLServer database:

import

 

Having previously installed the MySQL .Net connector, all I had to do was fill in the blanks. Server (with remote access enabled), database, username and password.

sqlserver-mgmt-import-1

The tricky part is mapping MySQL datatypes to SQLServer datatypes, and importing. Note that with a non-Express version of SQL Server Management Studio, you can save the schemas and automate the import.

sqlserver-mgmt-import

Download it and give it a whirl!