4

How to open and edit mdf sql server database files on linux?

I use ubuntu!

aF.
  • 64,980
  • 43
  • 135
  • 198
Tareq Nassry
  • 101
  • 1
  • 1
  • 7

2 Answers2

8

As of December 2016, there is a SQL Server version for Linux. The recommended approach would be to run SQL Server from the official Docker image:

Then it would be as simple as running SQL scripts against your database. There even exists a VS Code plugin for managing your databases: https://github.com/Microsoft/vscode-mssql.

Martín Coll
  • 3,368
  • 3
  • 37
  • 52
-16

Format hard disc, install Windows, install sql server, load databases (hint: mdf i not enough, you also may need the LDF file), then modify data as appropriate.

MDF files are quite complex internally and it i not as easy as editing them, sorry. They are SQL Server specific, so you will need SQL Server.

Arion
  • 31,011
  • 10
  • 70
  • 88
TomTom
  • 61,059
  • 10
  • 88
  • 148