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.

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

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

[GuidAttribute("D68202B5-1E2C-4A8F-B63E-64B2DB3F9280")]
public sealed class TransferSqlServerObjectsTask : Task, ITransferSqlServerObjectsTask, 
	IDTSBreakpointSite, IDTSSuspend, IDTSComponentPersist

NameDescription
System_CAPS_pubmethodTransferSqlServerObjectsTask()

Initializes a new instance of the TransferSqlServerObjectsTask class.

NameDescription
System_CAPS_pubpropertyCopyAllDefaults

Gets or sets a Boolean indicating that the transfer includes the SQL Server defaults.

System_CAPS_pubpropertyCopyAllDRIObjects

Gets or sets a value that indicates whether the task copies all objects that are related to declarative referential integrity (DRI).

System_CAPS_pubpropertyCopyAllLogins

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.

System_CAPS_pubpropertyCopyAllObjects

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.

System_CAPS_pubpropertyCopyAllPartitionFunctions

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.

System_CAPS_pubpropertyCopyAllPartitionSchemes

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.

System_CAPS_pubpropertyCopyAllRules

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.

System_CAPS_pubpropertyCopyAllSchemas

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.

System_CAPS_pubpropertyCopyAllSqlAssemblies

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.

System_CAPS_pubpropertyCopyAllStoredProcedures

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.

System_CAPS_pubpropertyCopyAllTables

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.

System_CAPS_pubpropertyCopyAllUserDefinedAggregates

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.

System_CAPS_pubpropertyCopyAllUserDefinedDataTypes

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.

System_CAPS_pubpropertyCopyAllUserDefinedFunctions

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.

System_CAPS_pubpropertyCopyAllUserDefinedTypes

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.

System_CAPS_pubpropertyCopyAllUsers

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.

System_CAPS_pubpropertyCopyAllViews

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.

System_CAPS_pubpropertyCopyAllXmlSchemaCollections

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.

System_CAPS_pubpropertyCopyData

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.

System_CAPS_pubpropertyCopyDatabaseRoles

Gets or sets a Boolean indicating whether database roles are transferred from the source to the target database.

System_CAPS_pubpropertyCopyDatabaseUsers

Gets or sets a Boolean indicating whether database users are transferred from the source to the target database.

System_CAPS_pubpropertyCopyForeignKeys

Gets or sets a Boolean indicating whether foreign keys are transferred from the source to the target database.

System_CAPS_pubpropertyCopyFullTextIndexes

Gets or sets a Boolean indicating whether full-text properties are transferred from the source to the target database.

System_CAPS_pubpropertyCopyIndexes

Gets or sets a Boolean indicating whether indexes are transferred from the source to the target database.

System_CAPS_pubpropertyCopyObjectLevelPermissions

Gets or sets a Boolean indicating whether securable objects are included in the transfer from the source to the target database.

System_CAPS_pubpropertyCopyPrimaryKeys

Gets or sets a Boolean indicating whether primary keys are transferred from the source to the target database.

System_CAPS_pubpropertyCopySchema

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.

System_CAPS_pubpropertyCopySqlServerLogins

Gets or sets a Boolean indicating whether SQL Server logins are included in the transfer from the source to the target database.

System_CAPS_pubpropertyCopyTriggers

Gets or sets a Boolean indicating whether triggers are included in the transfer from the source to the target database.

System_CAPS_pubpropertyDebugMode

Gets or sets a Boolean that indicates whether a task should determine whether breakpoints are enabled.

System_CAPS_pubpropertyDefaultsList

Gets or sets a StringCollection containing the default objects to transfer when the CopyAllDefaults is set to false.

System_CAPS_pubpropertyDestinationConnection

Gets or sets a String containing the name of the SMO connection manager for the destination database.

System_CAPS_pubpropertyDestinationDatabase

Gets or sets a String containing the name of the destination database.

System_CAPS_pubpropertyDestinationTranslateChar

Gets or sets a Boolean indicating the value of AutoTranslate in the OLE DB destination connection string.

System_CAPS_pubpropertyDropObjectsFirst

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.

System_CAPS_pubpropertyExecutionValue

Returns an object containing the count of the number of objects transferred.(Overrides Task.ExecutionValue.)

System_CAPS_pubpropertyExistingData

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.

System_CAPS_pubpropertyGenerateScriptsInUnicode

Gets or sets a Boolean that indicates whether the script generated is in Unicode format.

System_CAPS_pubpropertyIncludeDependentObjects

Gets or sets a Boolean that indicates whether the dependent objects are included in the transfer.

System_CAPS_pubpropertyIncludeExtendedProperties

Gets or sets a Boolean indicating whether extended properties are transferred from the source to the target database.

System_CAPS_pubpropertyLoginsList

Gets or sets a StringCollection containing the SQL Server logins to transfer from the source database to the destination database when CopyAllLogins is false.

System_CAPS_pubpropertyPartitionFunctionsList

Gets or sets a StringCollection containing the partition functions to transfer from the source database to the destination database when the CopyAllPartitionFunctions is false.

System_CAPS_pubpropertyPartitionSchemesList

Gets or sets a StringCollection containing the partition schemes to transfer from the source database to the destination database when CopyAllPartitionSchemes is false.

System_CAPS_pubpropertyRulesList

Gets or sets a StringCollection containing the rules to transfer from the source database to the destination database when CopyAllRules is false.

System_CAPS_pubpropertySchemasList

Gets or sets a StringCollection containing the list of schemas to transfer from the source database to the destination database when CopyAllSchemas is false.

System_CAPS_pubpropertySourceConnection

Gets or sets a String containing the name of the SMO connection manager for the source database.

System_CAPS_pubpropertySourceDatabase

Gets or sets a String containing the name of the database from which objects will be transferred.

System_CAPS_pubpropertySourceTranslateChar

Gets or sets a Boolean indicating the value of AutoTranslate in the OLE DB source connection string.

System_CAPS_pubpropertySqlAssembliesList

Gets or sets a StringCollection listing the SQL Server assemblies to transfer when CopyAllSqlAssemblies is false.

System_CAPS_pubpropertyStoredProceduresList

Gets or sets a StringCollection listing the stored procedures to transfer when CopyAllStoredProcedures is false.

System_CAPS_pubpropertySuspendRequired

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.

System_CAPS_pubpropertyTablesList

Gets or sets a StringCollection listing the tables to transfer when CopyAllTables is false.

System_CAPS_pubpropertyTargetServerVersion

(Inherited from Task.)

System_CAPS_pubpropertyUseCollation

Gets or sets a Boolean indicating whether the transfer should use collations.

System_CAPS_pubpropertyUserDefinedAggregatesList

Gets or sets a StringCollection listing the user-defined aggregates to transfer when CopyAllUserDefinedAggregates is false.

System_CAPS_pubpropertyUserDefinedDataTypesList

Gets or sets a StringCollection listing the user-defined data types to transfer when CopyAllUserDefinedDataTypes is false.

System_CAPS_pubpropertyUserDefinedFunctionsList

Gets or sets a StringCollection listing the user-defined functions to transfer when CopyAllUserDefinedFunctions is false.

System_CAPS_pubpropertyUserDefinedTypesList

Gets or sets a StringCollection listing the user-defined types to transfer when CopyAllUserDefinedTypes is false.

System_CAPS_pubpropertyUsersList

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.

System_CAPS_pubpropertyVersion

*** Member deprecated; see Remarks. ***   Returns the version of the task. This property is read-only.(Inherited from Task.)

System_CAPS_pubpropertyViewsList

Gets or sets a StringCollection listing the views to transfer when CopyAllViews is false.

System_CAPS_pubpropertyXmlSchemaCollectionsList

Gets or sets a StringCollection listing the XML schema collections to transfer when CopyAllXmlSchemaCollections is false.

NameDescription
System_CAPS_pubmethodAcceptBreakpointManager(BreakpointManager)

Passes a BreakpointManager to a task. This method is called by the runtime and is not used in code.

System_CAPS_pubmethodCanUpdate(String)

*** Member deprecated; see Remarks. ***   A Boolean that indicates whether the new package XML can update the old package XML.(Inherited from Task.)

System_CAPS_pubmethodEquals(Object)

Determines whether two object instances are equal.(Inherited from DtsObject.)

System_CAPS_pubmethodExecute(Connections, VariableDispenser, IDTSComponentEvents, IDTSLogging, Object)
System_CAPS_pubmethodGetConnectionID(Connections, String)

Gets a String containing the ID of the connection.(Inherited from Task.)

System_CAPS_pubmethodGetConnectionName(Connections, String)

Gets a String containing the name of the connection.(Inherited from Task.)

System_CAPS_pubmethodGetHashCode()

Returns the hash code for this instance.(Inherited from DtsObject.)

System_CAPS_pubmethodGetType()

(Inherited from Object.)

System_CAPS_pubmethodInitializeTask(Connections, VariableDispenser, IDTSInfoEvents, IDTSLogging, EventInfos, LogEntryInfos, ObjectReferenceTracker)

Initializes 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).)

System_CAPS_pubmethodLoadFromXML(XmlElement, IDTSInfoEvents)

This method is not callable by your application code. To load a package saved as .xml, use the Application.LoadPackage method.

System_CAPS_pubmethodResumeExecution()

Resumes execution of the task after pausing. The task or container is resumed by the run-time engine.

System_CAPS_pubmethodSaveToXML(XmlDocument, IDTSInfoEvents)

This method is not callable by your application code. To save a package as .xml, use the Application.SaveToXml method.

System_CAPS_pubmethodSuspendExecution()

Indicates that the executable needs to suspend. This method is called by the run-time engine.

System_CAPS_pubmethodToString()

(Inherited from Object.)

System_CAPS_pubmethodUpdate(String)

*** 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.)

System_CAPS_pubmethodValidate(Connections, VariableDispenser, IDTSComponentEvents, IDTSLogging)

Verifies that the task is properly configured.(Overrides Task.Validate(Connections, VariableDispenser, IDTSComponentEvents, IDTSLogging).)

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: