Raymond Camden's Blog Rss

Moving from SQL Server to MySQL

10

Posted in Development | Posted on 06-17-2006 | 3,748 views

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.)

Comments

[Add Comment] [Subscribe to Comments]

Nathan D said on 06-17-2006 at 9:52 AM #
Care to share what specifically is wrong with OpenOffice for the Mac?
Raymond Camden said on 06-17-2006 at 9:57 AM #
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.
Adrian J. Moreno said on 06-17-2006 at 6:25 PM #
Ray, have you tried MySQL's Migration Toolkit?

http://www.mysql.com/products/tools/migration-tool...

I've only used it to convert MS-Access, but it just took a few clicks and it was done.
Oliver Merk said on 06-17-2006 at 10:16 PM #
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.
Nathan D said on 06-18-2006 at 12:45 AM #
Have you looked at <a href="http://www.neooffice.org/">NeoOffice</a...;?
Raymond Camden said on 06-18-2006 at 6:47 AM #
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.
Tom Chiverton said on 06-19-2006 at 4:18 AM #
"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 !).
Raymond Camden said on 06-19-2006 at 7:42 AM #
Tom, thanks for the checking on that. I'll check them out again later.
Raymond Camden said on 06-26-2006 at 4:46 PM #
Ok, I take it back. The tool that Adrian reocmmended (the MySQL Migration tool) kicks major butt.
Deutsche Hotels said on 11-28-2008 at 4:39 PM #
Thanks, I downloaded MySQL Migration tool and will try it.

[Add Comment] [Subscribe to Comments]