共用方式為


Scripter 成員

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

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.

頂端

方法

  名稱 描述
公用方法 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。)

頂端

屬性

  名稱 描述
受保護的屬性 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。)

頂端

事件

  名稱 描述
公用事件 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.

頂端