Export (0) Print
Expand All

TransferSqlServerObjectsTask Class

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

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 (in Microsoft.SqlServer.TransferSqlServerObjectsTask.dll)

[GuidAttribute("A3859AE1-B057-465e-B106-51CAA03F8532")]
public sealed class TransferSqlServerObjectsTask : Task, 
	ITransferSqlServerObjectsTask, IDTSBreakpointSite, IDTSSuspend, IDTSComponentPersist

The TransferSqlServerObjectsTask type exposes the following members.

  NameDescription
Public methodTransferSqlServerObjectsTaskInitializes a new instance of the TransferSqlServerObjectsTask class.
Top

  NameDescription
Public propertyCopyAllDefaultsGets or sets a Boolean indicating that the transfer includes the SQL Server defaults.
Public propertyCopyAllDRIObjectsGets or sets a value that indicates whether the task copies all objects that are related to declarative referential integrity (DRI).
Public propertyCopyAllLogins Obsolete. 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.
Public propertyCopyAllObjectsGets 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.
Public propertyCopyAllPartitionFunctionsGets or sets a Boolean indicating whether all SQL Server partitions are transferred from the source to the target database, or only the specified partitions.
Public propertyCopyAllPartitionSchemesGets 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.
Public propertyCopyAllRulesGets or sets a Boolean indicating whether all SQL Server rules are transferred from the source to the target database, or only the specified rules.
Public propertyCopyAllSchemasGets or sets a Boolean indicating whether all SQL Server schemas are transferred from the source to the target database, or only the specified schemas.
Public propertyCopyAllSqlAssembliesGets or sets a Boolean indicating whether all SQL Server assemblies are transferred from the source to the target database, or only the specified assemblies.
Public propertyCopyAllStoredProceduresGets 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.
Public propertyCopyAllTablesGets or sets a Boolean indicating whether all SQL Server tables are transferred from the source to the target database, or only the specified tables.
Public propertyCopyAllUserDefinedAggregatesGets 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.
Public propertyCopyAllUserDefinedDataTypesGets 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.
Public propertyCopyAllUserDefinedFunctionsGets 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.
Public propertyCopyAllUserDefinedTypesGets 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.
Public propertyCopyAllUsers Obsolete. 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.
Public propertyCopyAllViewsGets or sets a Boolean indicating whether all SQL Server views are transferred from the source to the target database, or only the specified views.
Public propertyCopyAllXmlSchemaCollectionsGets 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.
Public propertyCopyDataGets 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.
Public propertyCopyDatabaseRolesGets or sets a Boolean indicating whether database roles are transferred from the source to the target database.
Public propertyCopyDatabaseUsersGets or sets a Boolean indicating whether database users are transferred from the source to the target database.
Public propertyCopyForeignKeysGets or sets a Boolean indicating whether foreign keys are transferred from the source to the target database.
Public propertyCopyFullTextIndexesGets or sets a Boolean indicating whether full-text properties are transferred from the source to the target database.
Public propertyCopyIndexesGets or sets a Boolean indicating whether indexes are transferred from the source to the target database.
Public propertyCopyObjectLevelPermissionsGets or sets a Boolean indicating whether securable objects are included in the transfer from the source to the target database.
Public propertyCopyPrimaryKeysGets or sets a Boolean indicating whether primary keys are transferred from the source to the target database.
Public propertyCopySchemaGets 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.
Public propertyCopySqlServerLoginsGets or sets a Boolean indicating whether SQL Server logins are included in the transfer from the source to the target database.
Public propertyCopyTriggersGets or sets a Boolean indicating whether triggers are included in the transfer from the source to the target database.
Public propertyDebugModeGets or sets a Boolean that indicates whether a task should determine whether breakpoints are enabled.
Public propertyDefaultsListGets or sets a StringCollection containing the default objects to transfer when the CopyAllDefaults is set to false.
Public propertyDestinationConnectionGets or sets a String containing the name of the SMO connection manager for the destination database.
Public propertyDestinationDatabaseGets or sets a String containing the name of the destination database.
Public propertyDestinationTranslateCharGets or sets a Boolean indicating the value of AutoTranslate in the OLE DB destination connection string.
Public propertyDropObjectsFirstGets 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.
Public propertyExecutionValueReturns an object containing the count of the number of objects transferred. (Overrides Task.ExecutionValue.)
Public propertyExistingDataGets 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.
Public propertyGenerateScriptsInUnicodeGets or sets a Boolean that indicates whether the script generated is in Unicode format.
Public propertyIncludeDependentObjectsGets or sets a Boolean that indicates whether the dependent objects are included in the transfer.
Public propertyIncludeExtendedPropertiesGets or sets a Boolean indicating whether extended properties are transferred from the source to the target database.
Public propertyLoginsListGets or sets a StringCollection containing the SQL Server logins to transfer from the source database to the destination database when CopyAllLogins is false.
Public propertyPartitionFunctionsListGets or sets a StringCollection containing the partition functions to transfer from the source database to the destination database when the CopyAllPartitionFunctions is false.
Public propertyPartitionSchemesListGets or sets a StringCollection containing the partition schemes to transfer from the source database to the destination database when CopyAllPartitionSchemes is false.
Public propertyRulesListGets or sets a StringCollection containing the rules to transfer from the source database to the destination database when CopyAllRules is false.
Public propertySchemasListGets or sets a StringCollection containing the list of schemas to transfer from the source database to the destination database when CopyAllSchemas is false.
Public propertySourceConnectionGets or sets a String containing the name of the SMO connection manager for the source database.
Public propertySourceDatabaseGets or sets a String containing the name of the database from which objects will be transferred.
Public propertySourceTranslateCharGets or sets a Boolean indicating the value of AutoTranslate in the OLE DB source connection string.
Public propertySqlAssembliesListGets or sets a StringCollection listing the SQL Server assemblies to transfer when CopyAllSqlAssemblies is false.
Public propertyStoredProceduresListGets or sets a StringCollection listing the stored procedures to transfer when CopyAllStoredProcedures is false.
Public propertySuspendRequiredGets 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.
Public propertyTablesListGets or sets a StringCollection listing the tables to transfer when CopyAllTables is false.
Public propertyUseCollationGets or sets a Boolean indicating whether the transfer should use collations.
Public propertyUserDefinedAggregatesListGets or sets a StringCollection listing the user-defined aggregates to transfer when CopyAllUserDefinedAggregates is false.
Public propertyUserDefinedDataTypesListGets or sets a StringCollection listing the user-defined data types to transfer when CopyAllUserDefinedDataTypes is false.
Public propertyUserDefinedFunctionsListGets or sets a StringCollection listing the user-defined functions to transfer when CopyAllUserDefinedFunctions is false.
Public propertyUserDefinedTypesListGets or sets a StringCollection listing the user-defined types to transfer when CopyAllUserDefinedTypes is false.
Public propertyUsersListGets or sets a StringCollection containing the SQL Server database users to transfer from the source database to the destination database when CopyAllUsers is false.
Public propertyVersion*** Member deprecated; see Remarks. ***   Returns the version of the task. This property is read-only. (Inherited from Task.)
Public propertyViewsListGets or sets a StringCollection listing the views to transfer when CopyAllViews is false.
Public propertyXmlSchemaCollectionsListGets or sets a StringCollection listing the XML schema collections to transfer when CopyAllXmlSchemaCollections is false.
Top

  NameDescription
Public methodAcceptBreakpointManagerPasses a BreakpointManager to a task. This method is called by the runtime and is not used in code.
Public methodCanUpdate*** Member deprecated; see Remarks. ***   A Boolean that indicates whether the new package XML can update the old package XML. (Inherited from Task.)
Public methodEqualsDetermines whether two object instances are equal. (Inherited from DtsObject.)
Public methodExecuteRuns the task. (Overrides Task.Execute(Connections, VariableDispenser, IDTSComponentEvents, IDTSLogging, Object).)
Protected methodFinalize (Inherited from Object.)
Public methodGetConnectionIDGets a String containing the ID of the connection. (Inherited from Task.)
Public methodGetConnectionNameGets a String containing the name of the connection. (Inherited from Task.)
Public methodGetHashCodeReturns the hash code for this instance. (Inherited from DtsObject.)
Public methodGetType (Inherited from Object.)
Public methodInitializeTaskInitializes the properties associated with the task. This method is called by the runtime and is not used in code. (Overrides Task.InitializeTask(Connections, VariableDispenser, IDTSInfoEvents, IDTSLogging, EventInfos, LogEntryInfos, ObjectReferenceTracker).)
Public methodLoadFromXMLThis method is not callable by your application code. To load a package saved as .xml, use the Application.LoadPackage method.
Protected methodMemberwiseClone (Inherited from Object.)
Public methodResumeExecutionResumes execution of the task after pausing. The task or container is resumed by the run-time engine.
Public methodSaveToXMLThis method is not callable by your application code. To save a package as .xml, use the Application.SaveToXml method.
Public methodSuspendExecutionIndicates that the executable needs to suspend. This method is called by the run-time engine.
Public methodToString (Inherited from Object.)
Public methodUpdate*** Member deprecated; see Remarks. ***   This method updates the old package XML with the new package XML if CanUpdate is set to true. (Inherited from Task.)
Public methodValidateVerifies that the task is properly configured. (Overrides Task.Validate(Connections, VariableDispenser, IDTSComponentEvents, IDTSLogging).)
Top

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft