Compartir a través de

Clase Scripter

  • Artículo

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

Jerarquía de herencia

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

Espacio de nombres:  Microsoft.SqlServer.Management.Smo
Ensamblado:  Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)

Sintaxis

'Declaración
Public Class Scripter _
    Inherits DependencyWalker
'Uso
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

El tipo Scripter expone los siguientes miembros.

Constructores

  Nombre Descripción
Método público Scripter() Initializes a new instance of the Scripter class.
Método público Scripter(Server) Initializes a new instance of the Scripter class on the specified instance of SQL Server.

Arriba

Propiedades

  Nombre Descripción
Propiedad protegida DependencyTree Gets or sets a server dependency tree. (Se hereda de DependencyWalker.)
Propiedad pública FilterCallbackFunction Gets or sets the scripting options that allow URNs to be filtered out while running the DiscoverDependencies method. (Se hereda de DependencyWalker.)
Propiedad protegida KnownObjectsList Gets or sets a list of all known objects in a server. (Se hereda de DependencyWalker.)
Propiedad pública Options Gets or sets the scripting options for the Scripter object and all the scripting operations on the instance of SQL Server.
Propiedad pública PrefetchObjects Gets or sets the Boolean property value that specifies whether the objects are loaded before scripting operations, or only as they are required.
Propiedad pública Server Gets or sets the instance of Microsoft SQL Server that the DependencyWalker tool object is associated with. (Se hereda de DependencyWalker.)
Propiedad protegida Total Gets or sets the number of objects that have been processed by the DependencyWalker object. (Se hereda de DependencyWalker.)
Propiedad protegida TotalCount Gets or sets the count of objects discovered by a dependency walker. (Se hereda de DependencyWalker.)

Arriba

Métodos

  Nombre Descripción
Método público 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. (Se hereda de DependencyWalker.)
Método público 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. (Se hereda de DependencyWalker.)
Método público DiscoverDependencies(array<Urn[], DependencyType) Creates a hierarchical object tree that represents the parent- or child-dependent relationships for a specified Urn array of SQL Server objects on the instance of SQL Server. (Se hereda de DependencyWalker.)
Método público DiscoverDependencies(array<Urn[], Boolean) Creates a hierarchical object tree that represents the parent- or child-dependent relationships for a specified Urn array of SQL Server objects on the instance of SQL Server. (Se hereda de DependencyWalker.)
Método público 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. (Se hereda de DependencyWalker.)
Método público 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. (Se hereda de DependencyWalker.)
Método públicoMiembro estático EnumDependencies Returns an enumerated list that includes the specified object and child or parent dependencies.
Método público EnumScript(array<SqlSmoObject[]) Returns an IEnumerable<script> object that contains a script.
Método público EnumScript(array<Urn[]) Returns an IEnumerable <script> interface.
Método público EnumScript(UrnCollection) Returns an IEnumerable <script> interface.
Método público EnumScriptWithList(DependencyCollection) Creates a linear Transact-SQL script based on a dependency collection.
Método público EnumScriptWithList(array<SqlSmoObject[]) Creates a linear Transact-SQL script based on an array of SqlSmoObjects.
Método público EnumScriptWithList(array<Urn[]) Creates a linear Transact-SQL script that is based on an array of URNs.
Método público EnumScriptWithList(UrnCollection) Creates a linear Transact-SQL script based on a URN collection.
Método público Equals (Se hereda de Object.)
Método protegido Finalize (Se hereda de Object.)
Método público GetHashCode (Se hereda de Object.)
Método protegido GetServerObject Returns the Server object that represents the instance of SQL Server on which the dependency discovery operation is running. (Se hereda de DependencyWalker.)
Método público GetType (Se hereda de Object.)
Método protegido Init Initializes the Scripter object.
Método protegido MemberwiseClone (Se hereda de Object.)
Método público Script(array<SqlSmoObject[]) Generates Transact-SQL scripts that can be used to re-create a list of objects.
Método público Script(array<Urn[]) Creates a Transact-SQL script for a set of objects that are specified with an array of Urn objects.
Método público Script(UrnCollection) Creates a Transact-SQL script for a set of objects that are specified with a Urn object collection.
Método público ScriptWithList(DependencyCollection) Creates linear Transact-SQL scripts for a DependencyCollection object. 
Método público ScriptWithList(array<SqlSmoObject[]) Creates linear Transact-SQL scripts for an array of SqlSmoObject objects. 
Método público ScriptWithList(array<Urn[]) Creates linear Transact-SQL scripts for an array of Urn objects. 
Método público ScriptWithList(UrnCollection) Creates linear Transact-SQL scripts for a UrnCollection object. 
Método público ToString (Se hereda de Object.)
Método público WalkDependencies Creates a linear list of objects and their dependencies from a specified DependencyTree object. (Se hereda de DependencyWalker.)

Arriba

Eventos

  Nombre Descripción
Evento público DiscoveryProgress Raises an event at intervals and reports progress on the DiscoveryProgress method. (Se hereda de DependencyWalker.)
Evento público ScriptingError Raises an event when an error occurs during a scripting operation.
Evento público ScriptingProgress Raises an event to receive information about the progress of the scripting operation.

Arriba

Comentarios

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

Todos los miembros estáticos (compartidos en Microsoft Visual Basic) públicos de este tipo son seguros para operaciones multiproceso. No se garantiza que los miembros de instancia sean seguros para subprocesos.

Ejemplos

Scripting

Seguridad para subprocesos

Cualquier miembro público static (Shared en Visual Basic) de este tipo es seguro para subprocesos. No se garantiza que los miembros de instancia sean seguros para subprocesos.

Vea también

Referencia

Espacio de nombres Microsoft.SqlServer.Management.Smo