Page 1 of 1

Convert mssql to mysql

Posted: Fri Dec 05, 2008 10:52 am
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?

Re: Convert mssql to mysql

Posted: Fri Dec 05, 2008 11:25 pm
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.

Re: Convert mssql to mysql

Posted: Sat Dec 06, 2008 2:43 pm
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.