Search code examples
sqlexportmdf

SQL Management Studio Exporting Data

I currently have a mdf database on management studio and I would like to export the data to a sql file. Exporting the data with the data-source: SQL Server Native Client works fine, but i have no idea where he saved the exported data. Any help?

Solution

  • You need to go in Database->Tasks->Generate Scripts.

    Select options there and you will able to generate complete db in SQL Script