Scripter 类

The Scripter object is the overall, top-level object for managing scripting operations.

继承层次结构

System. . :: . .Object
  Microsoft.SqlServer.Management.Smo. . :: . .DependencyWalker
    Microsoft.SqlServer.Management.Smo..::..Scripter

命名空间：  Microsoft.SqlServer.Management.Smo
程序集：  Microsoft.SqlServer.Smo（在 Microsoft.SqlServer.Smo.dll 中）

语法

声明
Public Class Scripter _
    Inherits DependencyWalker
用法
Dim instance As Scripter

public class Scripter : DependencyWalker

public ref class Scripter : public DependencyWalker

type Scripter =  
    class
        inherit DependencyWalker
    end

public class Scripter extends DependencyWalker

Scripter 类型公开以下成员。

构造函数

	名称	说明
	Scripter() () () ()	Initializes a new instance of the Scripter class.
	Scripter(Server)	Initializes a new instance of the Scripter class on the specified instance of SQL Server.

页首

属性

	名称	说明
	DependencyTree	Gets or sets a server Dependency Tree. （从 DependencyWalker 继承。）
	FilterCallbackFunction	Gets or sets the scripting options that allow URNs to be filtered out while running the DiscoverDependencies method. （从 DependencyWalker 继承。）
	KnownObjectsList	Gets or sets a list of all known objects in a server. （从 DependencyWalker 继承。）
	Options	Gets or sets the scripting options for the Scripter object and all the scripting operations on the instance of SQL Server.
	PrefetchObjects	Gets or sets the Boolean property value that specifies whether the objects are loaded before scripting operations, or only as they are required.
	Server	Gets or sets the instance of Microsoft SQL Server that the DependencyWalker tool object is associated with. （从 DependencyWalker 继承。）
	Total	（从 DependencyWalker 继承。）
	TotalCount	Gets or set the count of objects discovered by a Dependency Walker. （从 DependencyWalker 继承。）

页首

方法

	名称	说明
	DiscoverDependencies(array<Urn> [] () [] [], DependencyType)	（从 DependencyWalker 继承。）
	DiscoverDependencies(array<Urn> [] () [] [], Boolean)	（从 DependencyWalker 继承。）
	DiscoverDependencies(array<SqlSmoObject> [] () [] [], DependencyType)	Creates a hierarchical object tree that represents the parent or child dependent relationships for a specified object array of SQL Server objects on the instance of SQL Server. （从 DependencyWalker 继承。）
	DiscoverDependencies(array<SqlSmoObject> [] () [] [], Boolean)	Creates a hierarchical object tree that represents the parent or child dependent relationships for a specified object array of SQL Server objects on the instance of SQL Server. （从 DependencyWalker 继承。）
	DiscoverDependencies(UrnCollection, DependencyType)	Creates a hierarchical object tree that represents the parent or child dependent relationships for a specified Urn collection of SQL Server objects on the instance of SQL Server. （从 DependencyWalker 继承。）
	DiscoverDependencies(UrnCollection, Boolean)	Creates a hierarchical object tree that represents the parent or child dependent relationships for a specified Urn collection of SQL Server objects on the instance of SQL Server. （从 DependencyWalker 继承。）
	EnumDependencies	Returns an enumerated list that includes the specified object and child or parent dependencies.
	EnumScript(array<Urn> [] () [] [])
	EnumScript(array<SqlSmoObject> [] () [] [])	Returns an IEnumerable<script> object that contains a script.
	EnumScript(UrnCollection)	Returns an IEnumerable <script> interface.
	EnumScriptWithList(array<Urn> [] () [] [])
	EnumScriptWithList(DependencyCollection)	Creates a linear Transact-SQL script based on a dependency collection.
	EnumScriptWithList(array<SqlSmoObject> [] () [] [])	Creates a linear Transact-SQL script based on an array of SqlSmoObjects.
	EnumScriptWithList(UrnCollection)	Creates a linear Transact-SQL script based on a URN collection.
	Equals	（从 Object 继承。）
	Finalize	（从 Object 继承。）
	GetHashCode	（从 Object 继承。）
	GetServerObject	Returns the Server object that represents the instance of SQL Server on which the dependency discovery operation is running. （从 DependencyWalker 继承。）
	GetType	（从 Object 继承。）
	Init	Initializes the Scripter object.
	MemberwiseClone	（从 Object 继承。）
	Script(array<Urn> [] () [] [])
	Script(array<SqlSmoObject> [] () [] [])	Generates Transact-SQL scripts that can be used to re-create a list of objects.
	Script(UrnCollection)	Creates a Transact-SQL script for a set of objects that are specified with a Urn object collection.
	ScriptWithList(array<Urn> [] () [] [])
	ScriptWithList(DependencyCollection)	Creates linear Transact-SQL scripts for a DependencyCollection object.
	ScriptWithList(array<SqlSmoObject> [] () [] [])	Creates linear Transact-SQL scripts for an array of SqlSmoObject objects.
	ScriptWithList(UrnCollection)	Creates linear Transact-SQL scripts for a UrnCollection object.
	ToString	（从 Object 继承。）
	WalkDependencies	Creates a linear list of objects and their dependencies from a specified DependencyTree object. （从 DependencyWalker 继承。）

页首

事件

	名称	说明
	DiscoveryProgress	Raises an event at intervals and reports progress on the DiscoveryProgress method. （从 DependencyWalker 继承。）
	ScriptingError	Raises an event when an error occurs during a scripting operation.
	ScriptingProgress	Raises an event to receive information about the progress of the scripting operation.

页首

注释

The Scripter object allows programmatic access to scripting settings and is responsible for the following scripting functionality:

• Finding dependencies.

• Output script to memory and file.

• Calling the instance objects to be scripted.

• Managing context of a script operation, such as checking whether an object has already been scripted.

To get Scripter object properties, users can be a member of the public fixed server role.

To set Scripter object properties, users can be a member of the public fixed server role.

To run a script operation, users require permissions for the objects that are being scripted.

Thread Safety

此类型的任何公共静态（Microsoft Visual Basic 中的 Shared）成员在多线程操作中是安全的。 不保证所有实例成员都对于线程安全的。

示例

脚本撰写

线程安全

此类型的任何公共 static（在 Visual Basic 中为 Shared） 成员都是线程安全的。不保证所有实例成员都是线程安全的。

请参阅

参考

Microsoft.SqlServer.Management.Smo 命名空间