Convert mssql to mysql

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
vchris
Forum Contributor
Posts: 204
Joined: Tue Aug 30, 2005 7:53 pm
Location: Canada, Quebec

Convert mssql to mysql

Post by vchris »

I have a mssql database that I need to move to my new server which only supports mysql databases. I downloaded the mysql migration toolkit but it seems to only be able to migrate a database on a server. My old server is offline. All I have is a .bak file of my database on my computer. Is there an easy way to convert it to mysql?
User avatar
JAB Creations
DevNet Resident
Posts: 2341
Joined: Thu Jan 13, 2005 6:44 pm
Location: Sarasota Florida
Contact:

Re: Convert mssql to mysql

Post by JAB Creations »

So what you're saying is that the program converts it but can't output a file? That doesn't seem right to me though I haven't done a migration between database types.

A simple solution would to turn your current box in to a temporary sever, I use XAMPP for local testing and you'll have an Apache/PHP/MySQL server up and running in a matter of only a few minutes. Still I'd look for an option to output to a file rather than directly to a database.
User avatar
califdon
Jack of Zircons
Posts: 4484
Joined: Thu Nov 09, 2006 8:30 pm
Location: California, USA

Re: Convert mssql to mysql

Post by califdon »

I think he's saying that his only resource is the backed-up data file from MS SQL, for which he no longer has the SQL Server running. Do you know whether the backup is just a copy of the active database file, or an INSERT SQL file, which might allow you to just try loading it into MySQL? If you can use a hex editor to look at the file, are there ASCII SQL commands, or is it just raw data? Probably your best solution would be to find someplace that's running SQL Server and export your data in some format that can be used to import to MySQL.
Post Reply