且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

使用 SQL Server Server Management Studio 导入/导出数据库

更新时间:2021-12-04 23:16:32

右键单击数据库本身,Tasks -> Generate Scripts...

Right click the database itself, Tasks -> Generate Scripts...

然后按照向导操作.

对于 SSMS2008+,如果您还想导出数据,请在设置脚本选项"步骤中,选择高级"按钮并将脚本的数据类型"从仅架构"更改为仅数据"或架构和数据".

For SSMS2008+, if you want to also export the data, on the "Set Scripting Options" step, select the "Advanced" button and change "Types of data to script" from "Schema Only" to "Data Only" or "Schema and Data".