MSSQL -> MySQL?

[ast3r3x]

I have a friend who is trying to convert his Coldfusion/MSSQL drive database to PHP/MySQL. Does anyone know of a good way to convert the database tables to MySQL? I mean I didn't know if there was a way to export the MSSQL and import it into MySQL, I thought there was a way to do that with MySQL backups at least.

[ast3r3x]

Hmm...seems like the mysql site has a good page about it. Go figure. I wonder if I spelled something wrong earlier when I searched, I didn't get anything good.

[staph]

The "simplest" way is probably to export your data as CSV or TDT, and then use MySQL's LOAD DATA INFILE functionality to get it into MySQL. Of course, you'll need to recreate the schema by hand...

When you're exporting from MSSQL, don't choose the Unicode option like I foolishly did. It actually outputs UTF-16, which MySQL's parser will puke on. Sigh.