How to migrate / convert MSSQL .bak into Mysql / SQL

Here are the steps to follow in order to convert a MsSql (sql server) .BAK into mysql format:

  1. you need windows
  2. download and install Microsoft SQL Server Express
  3. download and install Microsoft SQL Server Management Studio Express
  4. download and install Mysql Migration Toolkit (included in Mysql Gui Tools only in Windows package, no linux version 🙁 )
  5. configure your MSSql server to listen on TCP connexion
  6. load your .bak in SQL Serveur management studio (right clic on database, restose database, from the unit, go to options tab and set a right path for the files listed in the .bak file, launch the recovery)
  7. in Mysql Migration toolkit, follow the wizard, it should be easy

Leave a Reply

Your email address will not be published. Required fields are marked *