Migrate MS SQL dump (.bak) to MySQL

Hello Experts,

I just got a .bak MS Sql dump from an old dead MS Sql server. How can I import the database in my MySQL server?

LVL 13
Daniel HelgenbergerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

My advice is to use a tool tons of them out there:


MySQL workbench
James MurrellProduct SpecialistCommented:
MySql have an application to import db from microsoft sql. Steps:

Open MySql Workbench
Click on "Database Migration" (if it do not appear you have to install it from MySql update)
Follow the Migration Task List using the simple Wizard.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Daniel HelgenbergerAuthor Commented:
Thanks alot cs97jjm3!

I installed MySql  workbench by chance today and even used Database Migration in the past; never having anything to do with MS Sql in my career and just got this task in this moment I would not even remotely come to my mind to use MySql workbench for that. Works like charm!
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
MySQL Server

From novice to tech pro — start learning today.