Compartilhar via


Classe TransferSqlServerObjectsTask

Contains the methods and properties that allow you to copy various SQL Server objects from one server to another. This class cannot be inherited.

Hierarquia de herança

System. . :: . .Object
  Microsoft.SqlServer.Dts.Runtime. . :: . .DtsObject
    Microsoft.SqlServer.Dts.Runtime. . :: . .Task
      Microsoft.SqlServer.Dts.Tasks.TransferSqlServerObjectsTask..::..TransferSqlServerObjectsTask

Namespace:  Microsoft.SqlServer.Dts.Tasks.TransferSqlServerObjectsTask
Assembly:  Microsoft.SqlServer.TransferSqlServerObjectsTask (em Microsoft.SqlServer.TransferSqlServerObjectsTask.dll)

Sintaxe

'Declaração
<GuidAttribute("A3859AE1-B057-465e-B106-51CAA03F8532")> _
Public NotInheritable Class TransferSqlServerObjectsTask _
    Inherits Task _
    Implements ITransferSqlServerObjectsTask, IDTSBreakpointSite, IDTSSuspend, IDTSComponentPersist
'Uso
Dim instance As TransferSqlServerObjectsTask
[GuidAttribute("A3859AE1-B057-465e-B106-51CAA03F8532")]
public sealed class TransferSqlServerObjectsTask : Task, 
    ITransferSqlServerObjectsTask, IDTSBreakpointSite, IDTSSuspend, IDTSComponentPersist
[GuidAttribute(L"A3859AE1-B057-465e-B106-51CAA03F8532")]
public ref class TransferSqlServerObjectsTask sealed : public Task, 
    ITransferSqlServerObjectsTask, IDTSBreakpointSite, IDTSSuspend, IDTSComponentPersist
[<SealedAttribute>]
[<GuidAttribute("A3859AE1-B057-465e-B106-51CAA03F8532")>]
type TransferSqlServerObjectsTask =  
    class
        inherit Task
        interface ITransferSqlServerObjectsTask
        interface IDTSBreakpointSite
        interface IDTSSuspend
        interface IDTSComponentPersist
    end
public final class TransferSqlServerObjectsTask extends Task implements ITransferSqlServerObjectsTask, IDTSBreakpointSite, IDTSSuspend, IDTSComponentPersist

O tipo TransferSqlServerObjectsTask expõe os membros a seguir.

Construtores

  Nome Descrição
Método público TransferSqlServerObjectsTask Initializes a new instance of the TransferSqlServerObjectsTask class.

Início

Propriedades

  Nome Descrição
Propriedade pública CopyAllDefaults Gets or sets a Boolean indicating that the transfer includes the SQL Server defaults.
Propriedade pública CopyAllDRIObjects Gets or sets a value that indicates whether the task copies all objects that are related to declarative referential integrity (DRI).
Propriedade pública CopyAllLogins Obsoleto. Gets or sets a Boolean indicating whether all the SQL Server logins are copied from the source database to the target database in the transfer operation, or only the specified logins.
Propriedade pública CopyAllObjects Gets or sets a Boolean indicating whether all SQL Server database objects are transferred from the source to the target database, or only the specified objects. The following SQL Server database objects can be transferred: defaults, rules, stored procedures, tables, triggers, user-defined data types, and views.
Propriedade pública CopyAllPartitionFunctions Gets or sets a Boolean indicating whether all SQL Server partitions are transferred from the source to the target database, or only the specified partitions.
Propriedade pública CopyAllPartitionSchemes Gets or sets a Boolean indicating whether all SQL Server partition schemes are transferred from the source to the target database, or only the specified partition schemes.
Propriedade pública CopyAllRules Gets or sets a Boolean indicating whether all SQL Server rules are transferred from the source to the target database, or only the specified rules.
Propriedade pública CopyAllSchemas Gets or sets a Boolean indicating whether all SQL Server schemas are transferred from the source to the target database, or only the specified schemas.
Propriedade pública CopyAllSqlAssemblies Gets or sets a Boolean indicating whether all SQL Server assemblies are transferred from the source to the target database, or only the specified assemblies.
Propriedade pública CopyAllStoredProcedures Gets or sets a Boolean indicating whether all SQL Server stored procedures are transferred from the source to the target database, or only the specified stored procedures.
Propriedade pública CopyAllTables Gets or sets a Boolean indicating whether all SQL Server tables are transferred from the source to the target database, or only the specified tables.
Propriedade pública CopyAllUserDefinedAggregates Gets or sets a Boolean indicating whether all user-defined aggregates are transferred from the source to the target database, or only the specified user-defined aggregates.
Propriedade pública CopyAllUserDefinedDataTypes Gets or sets a Boolean indicating whether all user-defined data types are transferred from the source to the target database, or only the specified user-defined data types.
Propriedade pública CopyAllUserDefinedFunctions Gets or sets a Boolean indicating whether all user-defined functions are transferred from the source to the target database, or only the specified user-defined functions.
Propriedade pública CopyAllUserDefinedTypes Gets or sets a Boolean indicating whether all user-defined types are transferred from the source to the target database, or only the specified user-defined types.
Propriedade pública CopyAllUsers Obsoleto. Gets or sets a Boolean indicating whether all the SQL Server database users are copied from the source database to the target database, or only the specified users.
Propriedade pública CopyAllViews Gets or sets a Boolean indicating whether all SQL Server views are transferred from the source to the target database, or only the specified views.
Propriedade pública CopyAllXmlSchemaCollections Gets or sets a Boolean indicating whether all XML schema collections are transferred from the source to the target database, or only the specified XML schema collections.
Propriedade pública CopyData Gets or sets a Boolean indicating whether data is included as part of the transfer of tables and views from the SQL Server source to the target database.
Propriedade pública CopyDatabaseRoles Gets or sets a Boolean indicating whether database roles are transferred from the source to the target database.
Propriedade pública CopyDatabaseUsers Gets or sets a Boolean indicating whether database users are transferred from the source to the target database.
Propriedade pública CopyForeignKeys Gets or sets a Boolean indicating whether foreign keys are transferred from the source to the target database.
Propriedade pública CopyFullTextIndexes Gets or sets a Boolean indicating whether full-text properties are transferred from the source to the target database.
Propriedade pública CopyIndexes Gets or sets a Boolean indicating whether indexes are transferred from the source to the target database.
Propriedade pública CopyObjectLevelPermissions Gets or sets a Boolean indicating whether securable objects are included in the transfer from the source to the target database.
Propriedade pública CopyPrimaryKeys Gets or sets a Boolean indicating whether primary keys are transferred from the source to the target database.
Propriedade pública CopySchema Gets or sets a Boolean that specifies whether the schema is copied in the transfer operation. This property is only available for SQL Server 2005 or later versions.
Propriedade pública CopySqlServerLogins Gets or sets a Boolean indicating whether SQL Server logins are included in the transfer from the source to the target database.
Propriedade pública CopyTriggers Gets or sets a Boolean indicating whether triggers are included in the transfer from the source to the target database.
Propriedade pública DebugMode Gets or sets a Boolean that indicates whether a task should determine whether breakpoints are enabled.
Propriedade pública DefaultsList Gets or sets a StringCollection containing the default objects to transfer when the CopyAllDefaults is set to false.
Propriedade pública DestinationConnection Gets or sets a String containing the name of the SMO connection manager for the destination database.
Propriedade pública DestinationDatabase Gets or sets a String containing the name of the destination database.
Propriedade pública DestinationTranslateChar Gets or sets a Boolean indicating the value of AutoTranslate in the OLE DB destination connection string.
Propriedade pública DropObjectsFirst Gets or sets a Boolean that indicates whether the objects that have been selected for transfer from the source are dropped first on the destination server before the transfer begins.
Propriedade pública ExecutionValue Returns an object containing the count of the number of objects transferred. (Substitui Task. . :: . .ExecutionValue.)
Propriedade pública ExistingData Gets or sets a value from the ExistingData enumeration to determine whether data should be appended to existing data, or have the existing data replaced by being overwritten.
Propriedade pública GenerateScriptsInUnicode Gets or sets a Boolean that indicates whether the script generated is in Unicode format.
Propriedade pública IncludeDependentObjects Gets or sets a Boolean that indicates whether the dependent objects are included in the transfer.
Propriedade pública IncludeExtendedProperties Gets or sets a Boolean indicating whether extended properties are transferred from the source to the target database.
Propriedade pública LoginsList Gets or sets a StringCollection containing the SQL Server logins to transfer from the source database to the destination database when CopyAllLogins is false.
Propriedade pública PartitionFunctionsList Gets or sets a StringCollection containing the partition functions to transfer from the source database to the destination database when the CopyAllPartitionFunctions is false.
Propriedade pública PartitionSchemesList Gets or sets a StringCollection containing the partition schemes to transfer from the source database to the destination database when CopyAllPartitionSchemes is false.
Propriedade pública RulesList Gets or sets a StringCollection containing the rules to transfer from the source database to the destination database when CopyAllRules is false.
Propriedade pública SchemasList Gets or sets a StringCollection containing the list of schemas to transfer from the source database to the destination database when CopyAllSchemas is false.
Propriedade pública SourceConnection Gets or sets a String containing the name of the SMO connection manager for the source database.
Propriedade pública SourceDatabase Gets or sets a String containing the name of the database from which objects will be transferred.
Propriedade pública SourceTranslateChar Gets or sets a Boolean indicating the value of AutoTranslate in the OLE DB source connection string.
Propriedade pública SqlAssembliesList Gets or sets a StringCollection listing the SQL Server assemblies to transfer when CopyAllSqlAssemblies is false.
Propriedade pública StoredProceduresList Gets or sets a StringCollection listing the stored procedures to transfer when CopyAllStoredProcedures is false.
Propriedade pública SuspendRequired Gets or sets a Boolean that indicates whether tasks should suspend when they encounter a breakpoint. This value is set by the run-time engine for tasks and containers when a breakpoint is encountered.
Propriedade pública TablesList Gets or sets a StringCollection listing the tables to transfer when CopyAllTables is false.
Propriedade pública UseCollation Gets or sets a Boolean indicating whether the transfer should use collations.
Propriedade pública UserDefinedAggregatesList Gets or sets a StringCollection listing the user-defined aggregates to transfer when CopyAllUserDefinedAggregates is false.
Propriedade pública UserDefinedDataTypesList Gets or sets a StringCollection listing the user-defined data types to transfer when CopyAllUserDefinedDataTypes is false.
Propriedade pública UserDefinedFunctionsList Gets or sets a StringCollection listing the user-defined functions to transfer when CopyAllUserDefinedFunctions is false.
Propriedade pública UserDefinedTypesList Gets or sets a StringCollection listing the user-defined types to transfer when CopyAllUserDefinedTypes is false.
Propriedade pública UsersList Gets or sets a StringCollection containing the SQL Server database users to transfer from the source database to the destination database when CopyAllUsers is false.
Propriedade pública Version *** Member deprecated; see Remarks. ***    Returns the version of the task. This property is read-only. (Herdado de Task.)
Propriedade pública ViewsList Gets or sets a StringCollection listing the views to transfer when CopyAllViews is false.
Propriedade pública XmlSchemaCollectionsList Gets or sets a StringCollection listing the XML schema collections to transfer when CopyAllXmlSchemaCollections is false.

Início

Métodos

  Nome Descrição
Método público AcceptBreakpointManager Passes a BreakpointManager to a task. This method is called by the runtime and is not used in code.
Método público CanUpdate *** Member deprecated; see Remarks. ***    A Boolean that indicates whether the new package XML can update the old package XML. (Herdado de Task.)
Método público Equals Determines whether two object instances are equal. (Herdado de DtsObject.)
Método público Execute Runs the task. (Substitui Task. . :: . .Execute(Connections, VariableDispenser, IDTSComponentEvents, IDTSLogging, Object).)
Método protegido Finalize (Herdado de Object.)
Método público GetConnectionID Gets a String containing the ID of the connection. (Herdado de Task.)
Método público GetConnectionName Gets a String containing the name of the connection. (Herdado de Task.)
Método público GetHashCode Returns the hash code for this instance. (Herdado de DtsObject.)
Método público GetType (Herdado de Object.)
Método público InitializeTask Initializes the properties associated with the task. This method is called by the runtime and is not used in code. (Substitui Task. . :: . .InitializeTask(Connections, VariableDispenser, IDTSInfoEvents, IDTSLogging, EventInfos, LogEntryInfos, ObjectReferenceTracker).)
Método público LoadFromXML This method is not callable by your application code. To load a package saved as .xml, use the Application..::..LoadPackage method.
Método protegido MemberwiseClone (Herdado de Object.)
Método público ResumeExecution Resumes execution of the task after pausing. The task or container is resumed by the run-time engine.
Método público SaveToXML This method is not callable by your application code. To save a package as .xml, use the Application..::..SaveToXml method.
Método público SuspendExecution Indicates that the executable needs to suspend. This method is called by the run-time engine.
Método público ToString (Herdado de Object.)
Método público Update *** Member deprecated; see Remarks. ***    This method updates the old package XML with the new package XML if CanUpdate is set to true. (Herdado de Task.)
Método público Validate Verifies that the task is properly configured. (Substitui Task. . :: . .Validate(Connections, VariableDispenser, IDTSComponentEvents, IDTSLogging).)

Início

Segurança de thread

Qualquer membro público static (Shared no Visual Basic) desse tipo é seguro para threads. Não há garantia de que qualquer membro de instância seja seguro para threads.