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.)
Archived Comments
Care to share what specifically is wrong with OpenOffice for the Mac?
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.
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.
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.
Have you looked at <a href="http://www.neooffice.org/">NeoOffice</a>?
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.
"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 !).
Tom, thanks for the checking on that. I'll check them out again later.
Ok, I take it back. The tool that Adrian reocmmended (the MySQL Migration tool) kicks major butt.
Thanks, I downloaded MySQL Migration tool and will try it.