How to import a SQL Server bak file into MySQL

Question

The title is self explanatory  Is there a way of directly doing such kind of importing

User · Answer

SQL Server databases are very Microsoft proprietary. Two options I can think of are:

Dump the database in CSV, XML or similar format that you'd then load into MySQL.
Setup ODBC connection to MySQL and then using DTS transport the data. As Charles Graham has suggested, you may need to build the tables before doing this. But that's as easy as a cut and paste from SQL Enterprise Manager windows to the corresponding MySQL window.

User · Answer

The method I used included part of Richard Harrison s method      So  install SQL Server 2008 Express   edition    This requires the download of the Web Platform Installer  wpilauncher n exe  Once you have this installed click on the database selection   you are also required to download Frameworks and Runtimes   After instalation go to the windows command prompt and      use sqlcmd -S  SQLExpress  whilst   logged in as administrator       then issue the following command       restore filelistonly from   disk  c  temp mydbName-2009-09-29-v10 bak     GO This will list the contents of the   backup - what you need is the first   fields that tell you the logical names   - one will be the actual database and the other the log file       RESTORE DATABASE mydbName FROM   disk  c  temp mydbName-2009-09-29-v10 bak  WITH     MOVE  mydbName  TO    c  temp mydbName data mdf       MOVE    mydbName log  TO    c  temp mydbName data ldf   GO   I fired up Web Platform Installer and from the what s new tab I installed SQL Server Management Studio and browsed the db to make sure the data was there     At that point i tried the tool included with MSSQL  SQL Import and Export Wizard   but the result of the csv dump only included the column names     So instead I just exported results of queries like  select   from users  from the SQL Server Management Studio

User · Answer

The  bak file from SQL Server is specific to that database dialect  and not compatible with MySQL   Try using etlalchemy to migrate your SQL Server database into MySQL  It is an open-sourced tool that I created to facilitate easy migrations between different RDBMS s    Quick installation and examples are provided here on the github page  and a more detailed explanation of the project s origins can be found here

User · Answer

I did not manage to find a way to do it directly   Instead I imported the bak file into SQL Server 2008 Express  and then used MySQL Migration Toolkit   Worked like a charm

User · Answer

I highly doubt it   You might want to use DTS SSIS to do this as Levi says   One think that you might want to do is start the process without actually importing the data   Just do enough to get the basic table structures together   Then you are going to want to change around the resulting table structure  because whatever structure tat will likely be created will be shaky at best   You might also have to take this a step further and create a staging area that takes in all the data first n a string  varchar  form   Then you can create a script that does validation and conversion to get it into the  real  database  because the two databases don t always work well together  especially when dealing with dates

User · Answer

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

User · Answer

In this problem  the answer is not updated in a timely  So it s happy to say that in 2020 Migrating to MsSQL into MySQL is that much easy  An online converter like RebaseData will do your job with one click  You can just upload your  bak file which is from MsSQL and convert it into  sql format which is readable to MySQL   Additional note  This can not only convert your  bak files but also this site is for all types of Database migrations that you want

User · Answer

The  BAK files from SQL server are in Microsoft Tape Format  MTF  ref  http   www fpns net willy msbackup htm  The bak file will probably contain the LDF and MDF files that SQL server uses to store the database   You will need to use SQL server to extract these  SQL Server Express is free and will do the job   So  install SQL Server Express edition  and open the SQL Server Powershell  There execute sqlcmd -S  lt COMPUTERNAME gt  SQLExpress  whilst logged in as administrator   then issue the following command   restore filelistonly from disk  c  temp mydbName-2009-09-29-v10 bak   GO   This will list the contents of the backup - what you need is the first fields that tell you the logical names - one will be the actual database and the other the log file   RESTORE DATABASE mydbName FROM disk  c  temp mydbName-2009-09-29-v10 bak  WITH     MOVE  mydbName  TO  c  temp mydbName data mdf       MOVE  mydbName log  TO  c  temp mydbName data ldf   GO   At this point you have extracted the database - then install Microsoft s  Sql Web Data Administrator   together with this export tool and you will have an SQL script that contains the database

User · Answer

Although my MySQL background is limited  I don t think you have much luck doing that  However  you should be able to migrate over all of your data by restoring the db to a MSSQL server  then creating a SSIS or DTS package to send your tables and data to the MySQL server   hope this helps

User · Answer

For those attempting Richard s solution above  here are some additional information that might help navigate common errors   1  When running restore filelistonly you may get Operating system error 5 Access is denied    If that s the case  open SQL Server Configuration Manager and change the login for SQLEXPRESS to a user that has local write privileges   2    This will list the contents of the backup - what you need is the first fields that tell you the logical names  - if your file lists more than two headers you will need to also account for what to do with those files in the RESTORE DATABASE command   If you don t indicate what to do with files beyond the database and the log  the system will apparently try to use the attributes listed in the  bak file   Restoring a file from someone else s environment will produce a  The path  has invalid attributes   It needs to be a directory   as the path in question doesn t exist on your machine   Simply providing a MOVE statement resolves this problem     In my case there was a third FTData type file  The MOVE command I added   MOVE  mydbName log  TO  c  temp mydbName data ldf   MOVE  sysft      TO  c  temp other     in my case I actually had to make a new directory for the third file   Initially I tried to send it to the same folder as the  mdf file but that produced a  failed to initialize correctly  error on the third FTData file when I executed the restore

[mysql] How to import a SQL Server .bak file into MySQL?

Examples related to mysql

Examples related to sql-server

Examples related to migration

Examples related to backup