SQL Management Studio Exporting Data

Question

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?

Nipun Ambastha · Accepted Answer · 2013-02-27 14:05:08Z

2

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

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

answered Feb 27, 2013 at 14:05

Nipun Ambastha

2,5931 gold badge17 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Jamie Over a year ago

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.

Collectives™ on Stack Overflow

SQL Management Studio Exporting Data

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related