0

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?

Brian Tompsett - 汤莱恩
  • 5,753
  • 72
  • 57
  • 129
Jamie
  • 93
  • 2
  • 13

1 Answers1

2

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

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

Nipun Ambastha
  • 2,553
  • 1
  • 16
  • 26
  • Thanks, there was an advanced option where you could choose the version to what version you would like to export the data to. This worked for me. – Jamie Mar 12 '13 at 15:12