如何将我的sql server 2008的架构导出到另一台计算机?

时间:2022-09-28 07:25:26

I have created a database on Sql Server 2008 and I want to export the schema (I don't need the data) to another computer?

我在Sql Server 2008上创建了一个数据库,我想将模式(我不需要数据)导出到另一台计算机上?

1 个解决方案

#1


3  

You can generate script to script out your schema to a sql file and then execute that in another server, right click on the database in management studio, select Task-> Generate Scripts

您可以生成脚本以将您的架构编写为sql文件,然后在另一台服务器中执行该脚本,右键单击management studio中的数据库,选择Task-> Generate Scripts

#1


3  

You can generate script to script out your schema to a sql file and then execute that in another server, right click on the database in management studio, select Task-> Generate Scripts

您可以生成脚本以将您的架构编写为sql文件,然后在另一台服务器中执行该脚本,右键单击management studio中的数据库,选择Task-> Generate Scripts