CODEWITHSUNDEEP
sql-serverimportexport
daniel
daniel

Reputation: 23

Import / Export database data with SQL Server Management Studio

I would like to import / export data using SQL Server Management Studio. I would like to get the data in the form of queries. Can it be done ?

Thanks.

Upvotes: 2

Views: 4515

Answers (2)

Robert Calhoun
Robert Calhoun

Reputation: 5133

Right click on database -> Tasks -> Generate Scripts...

when you get to "set scripting options", click "Advanced", then "type of data to script", change from "Schema only" to "Schema and Data" or "Data only".

Upvotes: 7

marc_s
marc_s

Reputation: 754488

Check out SSMS Tools Pack - it offers many things, one of them being a function to generate INSERT statements from your database tables.

Upvotes: 0

Related Questions