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

by

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 <COMPUTERNAME>\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.

More Related Contents:

  1. SQL Query needed for fetch value from Two identical table but not fully identical table
  2. Calculate Average of the largest values in multiple columns
  3. SQL Print the name of all Employees together with the name of their supervisor
  4. Does SQL Server Offer Anything Like MySQL’s ON DUPLICATE KEY UPDATE
  5. Storing JSON in database vs. having a new column for each key
  6. Can I restore a single table from a full mysql mysqldump file?
  7. MySQL LIMIT clause equivalent for SQL SERVER
  8. SQL: Repeat a result row multiple times, and number the rows
  9. How to take backup of a single table in a MySQL database?
  10. How do I decide when to use right joins/left joins or inner joins Or how to determine which table is on which side?
  11. The equivalent of SQLServer function SCOPE_IDENTITY() in mySQL?
  12. Is there a Profiler equivalent for MySql? [closed]
  13. Why do results from a SQL query not come back in the order I expect?
  14. Relationship between catalog, schema, user, and database instance
  15. Import MySQL database into a SQL Server
  16. How to export data from SQL Server 2005 to MySQL [closed]
  17. MySQL Aggregate Functions without GROUP BY clause
  18. Dump a mysql database to a plaintext (CSV) backup from the command line
  19. mysql equivalent data types
  20. How to transpose rows to columns with large amount of the data in BigQuery/SQL?
  21. How to migrate SQL Server database to MySQL? [closed]
  22. how to cast the hexadecimal to varchar(datetime)?
  23. What is the best way to do incremental backups in MySQL?
  24. MySQL – Meaning of “PRIMARY KEY”, “UNIQUE KEY” and “KEY” when used together while creating a table
  25. Equivalent of MSSQL IDENTITY Column in MySQL
  26. Equivalent of MySQL ON DUPLICATE KEY UPDATE in Sql Server
  27. What are the max number of allowable parameters per database provider type?
  28. Why in SQL NULL can’t match with NULL?
  29. Convert SQL Server query to MySQL [duplicate]
  30. comparison of truncate vs delete in mysql/sqlserver [duplicate]

Leave a Comment