Scripter Class
TOC
Collapse the table of content
Expand the table of content

Scripter Class

 

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

Namespace:   Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)


public class Scripter : DependencyWalker

NameDescription
System_CAPS_pubmethodScripter()

Initializes a new instance of the Scripter class.

System_CAPS_pubmethodScripter(Server)

Initializes a new instance of the Scripter class on the specified instance of SQL Server.

NameDescription
System_CAPS_protpropertyDependencyTree

Gets or sets a server dependency tree.(Inherited from DependencyWalker.)

System_CAPS_pubpropertyFilterCallbackFunction

Gets or sets the scripting options that allow URNs to be filtered out while running the DiscoverDependencies method.(Inherited from DependencyWalker.)

System_CAPS_protpropertyKnownObjectsList

Gets or sets a list of all known objects in a server.(Inherited from DependencyWalker.)

System_CAPS_pubpropertyOptions

Gets or sets the scripting options for the Scripter object and all the scripting operations on the instance of SQL Server.

System_CAPS_pubpropertyPrefetchObjects

Gets or sets the Boolean property value that specifies whether the objects are loaded before scripting operations, or only as they are required.

System_CAPS_pubpropertyServer

Gets or sets the instance of Microsoft SQL Server that the DependencyWalker tool object is associated with.(Inherited from DependencyWalker.)

System_CAPS_protpropertyTotal

Gets or sets the number of objects that have been processed by the DependencyWalker object.(Inherited from DependencyWalker.)

System_CAPS_protpropertyTotalCount

Gets or sets the count of objects discovered by a dependency walker.(Inherited from DependencyWalker.)

NameDescription
System_CAPS_pubmethodDiscoverDependencies(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.(Inherited from DependencyWalker.)

System_CAPS_pubmethodDiscoverDependencies(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.(Inherited from DependencyWalker.)

System_CAPS_pubmethodDiscoverDependencies(Urn[], Boolean)

Creates a hierarchical object tree that represents the parent- or child-dependent relationships for a specified T:Microsoft.SqlServer.Management.Smo.Urn array of SQL Server objects on the instance of SQL Server.(Inherited from DependencyWalker.)

System_CAPS_pubmethodDiscoverDependencies(Urn[], DependencyType)

Creates a hierarchical object tree that represents the parent- or child-dependent relationships for a specified T:Microsoft.SqlServer.Management.Smo.Urn array of SQL Server objects on the instance of SQL Server.(Inherited from DependencyWalker.)

System_CAPS_pubmethodDiscoverDependencies(UrnCollection, Boolean)

Creates a hierarchical object tree that represents the parent or child dependent relationships for a specified T:Microsoft.SqlServer.Management.Smo.Urn collection of SQL Server objects on the instance of SQL Server.(Inherited from DependencyWalker.)

System_CAPS_pubmethodDiscoverDependencies(UrnCollection, DependencyType)

Creates a hierarchical object tree that represents the parent or child dependent relationships for a specified T:Microsoft.SqlServer.Management.Smo.Urn collection of SQL Server objects on the instance of SQL Server.(Inherited from DependencyWalker.)

System_CAPS_pubmethodSystem_CAPS_staticEnumDependencies(SqlSmoObject, DependencyType)

Returns an enumerated list that includes the specified object and child or parent dependencies.

System_CAPS_pubmethodEnumScript(SqlSmoObject[])

Returns an IEnumerable<script> object that contains a script.

System_CAPS_pubmethodEnumScript(Urn[])

Returns an IEnumerable <script> interface.

System_CAPS_pubmethodEnumScript(UrnCollection)

Returns an IEnumerable <script> interface.

System_CAPS_pubmethodEnumScriptWithList(DependencyCollection)

Creates a linear Transact-SQL script based on a dependency collection.

System_CAPS_pubmethodEnumScriptWithList(SqlSmoObject[])

Creates a linear Transact-SQL script based on an array of SqlSmoObjects.

System_CAPS_pubmethodEnumScriptWithList(Urn[])

Creates a linear Transact-SQL script that is based on an array of URNs.

System_CAPS_pubmethodEnumScriptWithList(UrnCollection)

Creates a linear Transact-SQL script based on a URN collection.

System_CAPS_pubmethodEquals(Object)

(Inherited from Object.)

System_CAPS_protmethodFinalize()

(Inherited from Object.)

System_CAPS_pubmethodGetHashCode()

(Inherited from Object.)

System_CAPS_protmethodGetServerObject()

Returns the Server object that represents the instance of SQL Server on which the dependency discovery operation is running.(Inherited from DependencyWalker.)

System_CAPS_pubmethodGetType()

(Inherited from Object.)

System_CAPS_protmethodInit()

Initializes the Scripter object.

System_CAPS_protmethodMemberwiseClone()

(Inherited from Object.)

System_CAPS_pubmethodScript(SqlSmoObject[])

Generates Transact-SQL scripts that can be used to re-create a list of objects.

System_CAPS_pubmethodScript(Urn[])

Creates a Transact-SQL script for a set of objects that are specified with an array of T:Microsoft.SqlServer.Management.Smo.Urn objects.

System_CAPS_pubmethodScript(UrnCollection)

Creates a Transact-SQL script for a set of objects that are specified with a T:Microsoft.SqlServer.Management.Smo.Urn object collection.

System_CAPS_pubmethodScriptWithList(DependencyCollection)

Creates linear Transact-SQL scripts for a DependencyCollection object. 

System_CAPS_pubmethodScriptWithList(SqlSmoObject[])

Creates linear Transact-SQL scripts for an array of SqlSmoObject objects. 

System_CAPS_pubmethodScriptWithList(Urn[])

Creates linear Transact-SQL scripts for an array of T:Microsoft.SqlServer.Management.Smo.Urn objects. 

System_CAPS_pubmethodScriptWithList(UrnCollection)

Creates linear Transact-SQL scripts for a UrnCollection object. 

System_CAPS_pubmethodToString()

(Inherited from Object.)

System_CAPS_pubmethodWalkDependencies(DependencyTree)

Creates a linear list of objects and their dependencies from a specified DependencyTree object.(Inherited from DependencyWalker.)

NameDescription
System_CAPS_pubeventDiscoveryProgress

Raises an event at intervals and reports progress on the DiscoveryProgress method.(Inherited from DependencyWalker.)

System_CAPS_pubeventScriptingError

Raises an event when an error occurs during a scripting operation.

System_CAPS_pubeventScriptingProgress

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.

Any public static (Shared in Microsoft Visual Basic) members of this type are safe for multithreaded operations. Any instance members are not guaranteed to be thread safe.

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Return to top
Show:
© 2016 Microsoft