converting MS SQL file to MySQL database

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
alexus
Forum Contributor
Posts: 159
Joined: Fri Jul 04, 2003 10:49 pm

converting MS SQL file to MySQL database

Post 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!
User avatar
raghavan20
DevNet Resident
Posts: 1451
Joined: Sat Jun 11, 2005 6:57 am
Location: London, UK
Contact:

Post 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.
alexus
Forum Contributor
Posts: 159
Joined: Fri Jul 04, 2003 10:49 pm

Post 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
Post Reply