Moving from SQL Server to MySQL

development (This post is more than 2 years old.)

This blog post is mostly for me so I don't forget, but here is an excellent tool for migrating from SQL Server to MySQL: MSSQL2MySQL. The only drawback is that you need MS Office or VB installed to run the script. I still have MS Office on my desktop, but I don't use it anymore. I'm completely on OpenOffice now. (Except on the Mac - I'm still using Office there till OpenOffice for the Mac gets improved.)

Hire Me!

I'm currently looking for my next role in developer evangelism and advocacy. I have a long history of helping companies work with developers and love to write, create demos, and present at conferences. You can find my resume to learn more and drop me an email (raymondcamden@gmail.com) to reach out.

Support this Content!

If you like this content, please consider supporting me. You can become a Patron, visit my Amazon wishlist, or buy me a coffee! Any support helps!

Want to get a copy of every new post? Use the form below to sign up for my newsletter.

Archived Comments

Comment 1 by Nathan D posted on 6/17/2006 at 6:52 PM

Care to share what specifically is wrong with OpenOffice for the Mac?

Comment 2 by Raymond Camden posted on 6/17/2006 at 6:57 PM

I don't know why, but the version I had was ugly and slow. I think it is because it is running with x11 and isn't a native intel port. There -is- someone working on it, but it's not public yet.

Comment 3 by Adrian J. Moreno posted on 6/18/2006 at 3:25 AM

Ray, have you tried MySQL's Migration Toolkit?

http://www.mysql.com/produc...

I've only used it to convert MS-Access, but it just took a few clicks and it was done.

Comment 4 by Oliver Merk posted on 6/18/2006 at 7:16 AM

I've also used MySQL Migration Toolkit to convert a large ms-sql database to MySql. It worked flawlessly and I'd highly recommend it.

Comment 5 by Nathan D posted on 6/18/2006 at 9:45 AM

Have you looked at <a href="http://www.neooffice.org/">NeoOffice</a>?

Comment 6 by Raymond Camden posted on 6/18/2006 at 3:47 PM

Nathan, at the time I looked at it, the intel version wasn't available. Now I see it is - but it isn't free. A friend had an extra license of the Mac MS Office, so for now I'm just going to use it.

On a side note - it is amazing how nice the default Powerpoint templates look for the Mac. Maybe I'm just overly used to the defaults on the PC.

Anyway, if there is ever a free intel-based OpenOffice, I'll switch for sure.

Comment 7 by Tom Chiverton posted on 6/19/2006 at 1:18 PM

"the intel version wasn't available. Now I see it is - but it isn't free"
It will be from the start of next month, according to a comment on a recent /. story. Apperently it says so somewhere on their site.

Also, the final released version for Intel will be free (in case you were worried !).

Comment 8 by Raymond Camden posted on 6/19/2006 at 4:42 PM

Tom, thanks for the checking on that. I'll check them out again later.

Comment 9 by Raymond Camden posted on 6/27/2006 at 1:46 AM

Ok, I take it back. The tool that Adrian reocmmended (the MySQL Migration tool) kicks major butt.

Comment 10 by Deutsche Hotels posted on 11/29/2008 at 3:39 AM

Thanks, I downloaded MySQL Migration tool and will try it.