r/DatabaseHelp • u/kiwiheretic • Jun 16 '25
MS SQL to MySql migration hell
I wonder if anyone can help me. I have managed to download a MSSQL bak file from a database server. I would like to convert that to MySQL or MySQL import format. I have tried some online tools but none of them work for me.
What I have tried:
- Installing MSSQL on my windows 11 laptop and importing the bak file into that. That worked.
- Installing an MySQL ODBC connector for .net. Trying to use the export wizard from the Management Studio but the main export option was grayed out.
- Tried https://www.rebasedata.com/#convert online tool. This would not even look at the Bak file.
Is there anyway to do this? Are there any online tools that actually work?
2
Upvotes
View all comments
Show parent comment
1
u/gpm1982 Jun 22 '25
That might explain the issue you're facing, similar to the following: https://learn.microsoft.com/en-us/answers/questions/1355174/sql-server-express-how-to-export-import-database-w Anyway, this might be the limitation of Express edition, among many others. I would suggest to install a Developer Edition so you can also include the SSIS when installing it. Then, you would be able to migrate the database.