Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I have a MSSQL 2008 .bak file from a database that I need to migrate to MySQL. Is there some way to do this without having to install Window$ and SQL Server there ? Other options would be to do the migration online, even though that would take some time, what would be the best tools for that ?

share|improve this question

1 Answer 1

up vote 1 down vote accepted

Installing a Windows Server evaluation version and an SQL Server evaluation or Express version (if your BAK file is under the maximum size for the version of SQL Server Express that you intend to use) is going to be the method that will provide you assured integrity of the data you're trying to export.

I'm not aware of any Free or no-cost third-party methods to read SQL Server "BAK" files, but since you can obtain all the tools from Microsoft to perform the export at no-cost anyway I'm not sure why you wouldn't want to use their tools. You're going to be assured, with their tools, that the data you export from the database is correct.

In this answer I'm assuming that you're talking about migrating some data in tables and that you're aware that more advanced features aren't going to just seamlessly migrate from Microsoft SQL Server to MySQL.

share|improve this answer
    
The data I need to migrate is very simple, I could of course write a simple asp.net script to export the tables as .csv and then put that into MySQL, I was just looking for a simpler solution if one existed. I don't need any of the advanced features of SQL Server, it is overkill for my needs in this project. –  Iceman Mar 29 '11 at 15:41
1  
Red Gate's virtual restore does allow you to read .bak backup files, but it doesn't let you pump into into anything. –  Peter Schofield Mar 29 '11 at 16:23
    
Thank you, but that's a Windows program. I need something on Linux/Ubuntu that I can use if that utility exists. –  Iceman Mar 30 '11 at 9:07
    
I'm marking this down as an answer since there doesn't seem to be a way to do this besides the "normal" way of doing it. –  Iceman Mar 31 '11 at 9:49

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.