How to open mdf file microsoft sql server database?

R

Rostislav2014-01-13 17:00:09

Microsoft SQL Server Management Studio

Rostislav, 2014-01-13 17:00:09

Can you please tell me how to open the mdf file and possibly extract data from it in Excel or csv format?

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

P

Pavlo Barmak, 2014-01-13
@postislav

Open:
1) Install Microsoft SQL Server Management Studio
2) Run there:

EXEC sp_attach_db @dbname = N'<имя_базы>', 
   @filename1 = N'<путь_к_файлу_mdf>'

EMS Data Export for SQL Server can export to different formats (including Excel and CSV).