Yep, it’s that simple, just run the command mysql -u USER -p DATABASE mysql -u root -p test SEARCH FOR “SYSTEM ENVIRONMENT”Ī3) COMMAND-LINE EXPORT D:\http\>mysqldump -u root -p test > d:\http\test.sql We will use the command line to import SQL files, without the hassle of installing any extra tools.Ī1) IMPORT COMMAND EXAMPLE D:\http\>mysql -u root -p test Personally I repeated the procedure many times without issues so I cannot predict any problem if you encounter some, please leave a note on the comments and I will gladly help you.This first method is just as mentioned in the introduction. Now you have the MSSQL bak files regularly imported on your MySQL server and eventually, if you have chosen so on point #17, a sql file to replicate the import on another MySQL server without repeating all the procedure. You will see a final view of the report click “Finish”.In the “Bulk Data Transfer” you can see the import progress and when finished, click “Next”.Unless you do not want to change the parameters of “Data Copy”, click “Next”.If the next two screens do not give errors click “Next”.If you receive a notice that the database on MySQl need to be emptied, click “Yes” (unless you want it to hold in this case to say “No” and make a backup before repeating the procedure “.Choose “Create in target RDBMS schema” and, if later on you want to do the real import on a production MySQL server, “Create a SQL script file” and click “Next”.If the next two screens do not give any errors, click “Next”.Select “Migrate Table objects” and click “Next”.If the screen does not give any errors, click “Next”.Select the database and the subheading and click “Next”.If the screen does not give any errors click “Next”.As “Target RDBMS” put the information of your MySQL server and click “Next”.As “Database System” select “Microsoft SQL Server” – as “Connection Method” choose “ODBC (native)” – leave “User Name” empty – choose “Next”.Click on “Database Migration” and then “Start Migration” (bottom).Once you finish the import, open MySQL Workbench.In the “Destination” to choose the name you want to give to the database and click “OK” – now the bak file is being imported on MSSQL.click on the 3 dots (…), select “Add”, choose the bak file of point 1 and click “OK.On the list on the left, click the right button on Database and select “Restore Database”.Remove any previous import of database (it may exist if you regularly have to import MSSQL bak files to MySQL).Open “SQL Server 2014 Management Studio”.Once you have installed all the prerequisite programs, place the MSSQL bak file you want to import to MySQL in “C:\Program Files\ Microsoft SQL Server\ MSSQL12.SQLEXPRESS\MSSQL\ Backup”.
To import MSSQL bak files to MySQL you need:īeside the computer, that you may already have, all programs are free. Are you a web developer or a system admin that is used to work with MySQL, but for a specific project you are provided with a MSSQL BAK file? If the MSSQL BAK file is no bigger than 10 GB, you are lucky: you can import MSSQL bak files to MySQL without paying for a licence of MS SQL as you can use “MS SQL Server Express Edition”.