Classe Scripter

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

Gerarchia di ereditarietà

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

Spazio dei nomi  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Sintassi

'Dichiarazione
Public Class Scripter _
    Inherits DependencyWalker
'Utilizzo
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

Nel tipo Scripter sono esposti i membri seguenti.

Costruttori

  Nome Descrizione
Metodo pubblico Scripter() Initializes a new instance of the Scripter class.
Metodo pubblico Scripter(Server) Initializes a new instance of the Scripter class on the specified instance of SQL Server.

In alto

Proprietà

  Nome Descrizione
Proprietà protetta DependencyTree Gets or sets a server dependency tree. Ereditato da DependencyWalker.
Proprietà pubblica FilterCallbackFunction Gets or sets the scripting options that allow URNs to be filtered out while running the DiscoverDependencies method. Ereditato da DependencyWalker.
Proprietà protetta KnownObjectsList Gets or sets a list of all known objects in a server. Ereditato da DependencyWalker.
Proprietà pubblica Options Gets or sets the scripting options for the Scripter object and all the scripting operations on the instance of SQL Server.
Proprietà pubblica PrefetchObjects Gets or sets the Boolean property value that specifies whether the objects are loaded before scripting operations, or only as they are required.
Proprietà pubblica Server Gets or sets the instance of Microsoft SQL Server that the DependencyWalker tool object is associated with. Ereditato da DependencyWalker.
Proprietà protetta Total Gets or sets the number of objects that have been processed by the DependencyWalker object. Ereditato da DependencyWalker.
Proprietà protetta TotalCount Gets or sets the count of objects discovered by a dependency walker. Ereditato da DependencyWalker.

In alto

Metodi

  Nome Descrizione
Metodo pubblico 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. Ereditato da DependencyWalker.
Metodo pubblico 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. Ereditato da DependencyWalker.
Metodo pubblico 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. Ereditato da DependencyWalker.
Metodo pubblico 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. Ereditato da DependencyWalker.
Metodo pubblico 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. Ereditato da DependencyWalker.
Metodo pubblico 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. Ereditato da DependencyWalker.
Metodo pubblicoMembro statico EnumDependencies Returns an enumerated list that includes the specified object and child or parent dependencies.
Metodo pubblico EnumScript(array<SqlSmoObject[]) Returns an IEnumerable<script> object that contains a script.
Metodo pubblico EnumScript(array<Urn[]) Returns an IEnumerable <script> interface.
Metodo pubblico EnumScript(UrnCollection) Returns an IEnumerable <script> interface.
Metodo pubblico EnumScriptWithList(DependencyCollection) Creates a linear Transact-SQL script based on a dependency collection.
Metodo pubblico EnumScriptWithList(array<SqlSmoObject[]) Creates a linear Transact-SQL script based on an array of SqlSmoObjects.
Metodo pubblico EnumScriptWithList(array<Urn[]) Creates a linear Transact-SQL script that is based on an array of URNs.
Metodo pubblico EnumScriptWithList(UrnCollection) Creates a linear Transact-SQL script based on a URN collection.
Metodo pubblico Equals Ereditato da Object.
Metodo protetto Finalize Ereditato da Object.
Metodo pubblico GetHashCode Ereditato da Object.
Metodo protetto GetServerObject Returns the Server object that represents the instance of SQL Server on which the dependency discovery operation is running. Ereditato da DependencyWalker.
Metodo pubblico GetType Ereditato da Object.
Metodo protetto Init Initializes the Scripter object.
Metodo protetto MemberwiseClone Ereditato da Object.
Metodo pubblico Script(array<SqlSmoObject[]) Generates Transact-SQL scripts that can be used to re-create a list of objects.
Metodo pubblico Script(array<Urn[]) Creates a Transact-SQL script for a set of objects that are specified with an array of Urn objects.
Metodo pubblico Script(UrnCollection) Creates a Transact-SQL script for a set of objects that are specified with a Urn object collection.
Metodo pubblico ScriptWithList(DependencyCollection) Creates linear Transact-SQL scripts for a DependencyCollection object. 
Metodo pubblico ScriptWithList(array<SqlSmoObject[]) Creates linear Transact-SQL scripts for an array of SqlSmoObject objects. 
Metodo pubblico ScriptWithList(array<Urn[]) Creates linear Transact-SQL scripts for an array of Urn objects. 
Metodo pubblico ScriptWithList(UrnCollection) Creates linear Transact-SQL scripts for a UrnCollection object. 
Metodo pubblico ToString Ereditato da Object.
Metodo pubblico WalkDependencies Creates a linear list of objects and their dependencies from a specified DependencyTree object. Ereditato da DependencyWalker.

In alto

Eventi

  Nome Descrizione
Evento pubblico DiscoveryProgress Raises an event at intervals and reports progress on the DiscoveryProgress method. Ereditato da DependencyWalker.
Evento pubblico ScriptingError Raises an event when an error occurs during a scripting operation.
Evento pubblico ScriptingProgress Raises an event to receive information about the progress of the scripting operation.

In alto

Osservazioni

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

Tutti i membri statici pubblici (Shared in Microsoft Visual Basic) di questo tipo sono sicuri per le operazioni a thread multipli. Non è invece garantita la sicurezza dei membri dell'istanza.

Esempi

Generazione di script

Protezione dei thread

I membri static (Shared in Visual Basic) pubblici di questo tipo sono affidabili. Non è invece garantita la sicurezza dei membri dell'istanza.

Vedere anche

Riferimento

Spazio dei nomi Microsoft.SqlServer.Management.Smo