Page 1 of 1
converting MS SQL file to MySQL database
Posted: Mon May 01, 2006 9:05 pm
by alexus
Hi, I've been given a backup file of MS SQL 2000, I need to convert it to a MySQL database... any ideas on how i can do that?
Thanks!
Posted: Wed May 03, 2006 1:28 am
by raghavan20
Can you post a few lines of MS SQL code, I am just trying to find whether there are significant differences in the SQL syntax. The best way to re-create a different db is, you can generate a CSV or an XML file from MS SQL and then upload that to MySQL.
Posted: Wed May 03, 2006 6:31 am
by alexus
yea, the CSV is relatively easy case...
as to the lines I dont have any lines, i have backup file which was exported (by other person) when we moved to another hosting. When I'm opening it in WordPad im getting some weired encoding which is unreadable