MSSQL .bak file

Krik

I hope this is the right place for this question

I am not going into all the details on this as it would be to long a story.

But I have a .bak file from a Microsoft SQL database. After viewing it, I am guessing it is binary file.

The question, is it possible to import the data into MySQL. Now obviously doing this via code would be more work that its worth for one file. So I looked into phpmyadmin and it appears to have the ability to import and MSSQL files. The problem is I get an error when I try. So I guess there is more to it than I meets the eye. Should also note that phpmyadmin will allow me to import it as a binary file or an asccii file as well as few other formats.

Any one know more about this.

Should note as I was browsing the file in notepad++ I see a lot of "null" characters mixed with special character. And then there will be blocks of code like this sample

set @sql = 'SELECT (vreportworkorders.branchname) As branchname,vreportworkorders.routename,(vreportworkoqders.woheaderid) As woheaderid, vreportworkorders.scheduledate,vreportworkorders.printeddate,
 (vreportworkorders.accountnum) As accountnum,(vreportworkorders.eventname) as Event,
--WHEN 1 THEN vreportworkorders.eventname  ELSE vreportworkorders.programname
-- END as Description,

As well the data is viewable just, as anyone would imagine, it is just all over the place and sometimes intermixed with special character.

Don't know if any of that helps you point me in the right direction but thought it couldn't hurt.

tomhath

As far as I know you need to get a copy of SQL Server and restore the backup to it. A trial edition should be all you need. I kind of wonder why you have a database backup without the database though.

http://www.microsoft.com/sqlserver/2005/en/us/trial-software.aspx

Once you have the database restored you could query it from SQL Server or write a DTS package to transfer it to MySQL.

Krik

Trial version that is a good idea.

tomhath;10907325 wrote:
I kind of wonder why you have a database backup without the database though.

Like I said its along story. Basically a company I was doing some web work for asked if I knew how to get the data into a MySQL database. The backup is from an online service they had subscribed to keep customer records. As the online service was quite out to lunch on several things they canceled the subscription last year and requested a backup of the data (obviously both sides had different ideas of what a backup is). Most the data was hand transferred before they canceled their subscription but they have found a few things missing and asked if I knew anything about it.