Moving from SQL Server to MySQL

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 (9) Jun 17, 2006 9:36 AM Views: 2206

Comments

[Add Comment]
Care to share what specifically is wrong with OpenOffice for the Mac?
# Posted By Nathan D | 6/17/06 9:52 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.
# Posted By Raymond Camden | 6/17/06 9:57 AM
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.
# Posted By Adrian J. Moreno | 6/17/06 6:25 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.
# Posted By Oliver Merk | 6/17/06 10:16 PM
Have you looked at <a href="http://www.neooffice.org/">NeoOffice</a...;?
# Posted By Nathan D | 6/18/06 12:45 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.
# Posted By Raymond Camden | 6/18/06 6:47 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 !).
# Posted By Tom Chiverton | 6/19/06 4:18 AM
Tom, thanks for the checking on that. I'll check them out again later.
# Posted By Raymond Camden | 6/19/06 7:42 AM
Ok, I take it back. The tool that Adrian reocmmended (the MySQL Migration tool) kicks major butt.
# Posted By Raymond Camden | 6/26/06 4:46 PM
[Add Comment]