Transfering DB from MS SQL to MySQL

[wfernley]

I was curious how I can transfer my DB from MS SQL to MySQL. Would Excel be the best, MDF or Microsoft Access?

I know nothign about MS SQL so please forgive me for not really knowing what I'm talking about ;)

Wes

[txbakers]

Hi, I'm going to move this up to Microsoft where the MS SQL people like to visit.

thanks for posting.

[mattglet]

My opinion would be to export MS SQL to text file, then import into mySQL.

-Matt

[mcavic]

Yes, export from MS SQL to a comma or tab delimited file using the Export Data wizard thing, then import to MySQL using the Load Data [dev.mysql.com] command.