0

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 ?

1 Answer 1

1

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.

4
  • 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.
    – Eyeslandic
    Mar 29, 2011 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. Mar 29, 2011 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.
    – Eyeslandic
    Mar 30, 2011 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.
    – Eyeslandic
    Mar 31, 2011 at 9:49

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .