MySQL to SQLServer 2008 Express [redux]

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:



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.


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.


Download it and give it a whirl!

Skip to main content