25 chars of wasted space.
|
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.
|
quote |
25 chars of wasted space.
|
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.
|
quote |
Microbial member
|
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. |
quote |
Posting Rules | Navigation |
|
Thread Tools | |
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Save arrays in MySQL | nassau | Programmer's Nook | 2 | 2006-07-08 12:24 |
MySQL database disabled, how to "restart" it? | drewprops | Programmer's Nook | 3 | 2005-12-31 19:17 |
MySQL in OSX | nassau | Programmer's Nook | 2 | 2005-12-12 12:04 |
MySQL 5.0 Install on OS X v.10.4.1- need help with socket error | DogMom | Genius Bar | 1 | 2005-07-11 17:00 |
Guitar -> Monster iStudioLink -> GarageBand | appleguitar | Apple Products | 7 | 2005-01-27 20:13 |