SQL Server 2008-使用命令行创建数据库脚本（模式+数据）

问题描述

在SSMS中，当我单击数据库任务->生成脚本时，得到一个输出脚本。

In SSMS when I click on the database "Tasks -> Generate Scripts", I get an output script.

如何使用非图形工具执行同样的操作？

How do I do the same with a non-graphical tool?

推荐答案

图形工具只是实际实现脚本的SMO类的包装，例如类。在MSDN中，有一个使用SMO编写数据库中所有表脚本的示例：：

The graphical tool is just a wrapper around the SMO classes that actually implement scripting, like the Scripter class. There is an example of scripting all tables in a database with SMO in MSDN: Scripting:

//Connect to the local, default instance of SQL Server.
{
   Server srv = default(Server);
   srv = new Server();
   //Reference the AdventureWorks database.
   Database db = default(Database);
   db = srv.Databases("AdventureWorks");
   //Define a Scripter object and set the required scripting options.
   Scripter scrp = default(Scripter);
   scrp = new Scripter(srv);
   scrp.Options.ScriptDrops = false;
   scrp.Options.WithDependencies = true;
   //Iterate through the tables in database and script each one. Display the script.
   //Note that the StringCollection type needs the System.Collections.Specialized namespace to be included.
   Table tb = default(Table);
   Urn[] smoObjects = new Urn[2];
   foreach ( tb in db.Tables) {
      smoObjects = new Urn[1];
      smoObjects(0) = tb.Urn;
      if (tb.IsSystemObject == false) {
         StringCollection sc = default(StringCollection);
         sc = scrp.Script(smoObjects);
         string st = null;
         foreach ( st in sc) {
            Console.WriteLine(st);
         }
      }
   }
}

有还有更多如何在其他各种网站上使用它的示例。

There are many more examples how to use it on various other sites.

这篇关于SQL Server 2008-使用命令行创建数据库脚本（模式+数据）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！