Import / Export database data with SQL Server Mana

2019-07-18 06:07发布

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.

2条回答
祖国的老花朵
2楼-- · 2019-07-18 06:13

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

查看更多
三岁会撩人
3楼-- · 2019-07-18 06:24

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

查看更多
登录 后发表回答