将数据库转换为sql脚本的技术?

I want to convert a database into an sql script so that i can recreate it elsewhere. I want the copy to be same as original.

我希望将数据库转换为sql脚本，以便可以在其他地方重新创建它。我想要一份和原件一样的。

How do i do that ?

我该怎么做呢?

2 个解决方案

#1

You can generate DB Script using Management Studio through available option.

您可以使用Management Studio通过available选项生成DB脚本。

Right Click on Database -> Task -> Generate Scripts

Here is an option for including Data with Schema in script

下面是在脚本中包含带有模式的数据的选项

#2

In SQL Management Studio, right click on the database, select Tasks->Generate Scripts. It will guide you through a wizard.

在SQL Management Studio中，右键单击数据库，选择Tasks->生成脚本。它将引导你通过一个向导。