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
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.
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...;?
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.
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 !).
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
Thanks, I downloaded MySQL Migration tool and will try it.
# Posted By Deutsche Hotels
| 11/28/08 4:39 PM