Import / Export database data with SQL Server Mana

问题:

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.

回答1:

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

回答2:

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".