User Name
Password
AppleNova Forums » Programmer's Nook »

MSSQL -> MySQL?


Register Members List Calendar Search FAQ Posting Guidelines
MSSQL -> MySQL?
Thread Tools
ast3r3x
25 chars of wasted space.
 
Join Date: May 2004
Send a message via AIM to ast3r3x  
2006-11-02, 09:00

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
ast3r3x
25 chars of wasted space.
 
Join Date: May 2004
Send a message via AIM to ast3r3x  
2006-11-02, 10:01

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
staph
Microbial member
 
Join Date: May 2004
Send a message via AIM to staph  
2006-11-02, 16:38

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
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Post Reply

Forum Jump
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


« Previous Thread | Next Thread »

All times are GMT -5. The time now is 11:17.


Powered by vBulletin®
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004 - 2024, AppleNova