2.7.1.22 TransferSqlServerObjectsTaskDataObjectDataType

  • Article

The TransferSqlServerObjectsTaskDataObjectDataType complex type is used to specify parameters, properties, and settings that are specific to the Transfer Database Task. 

The following is the XSD for the TransferSqlServerObjectsTaskDataObjectDataType complex type.

   <xs:complexType name="TransferSqlServerObjectsTaskDataObjectDataType">
     <xs:sequence/>
     <xs:attribute name="SourceConnection" type="xs:string"
                   form="unqualified"/>
     <xs:attribute name="DestinationConnection" type="xs:string"
                   form="unqualified"/>
     <xs:attribute name="SourceDatabase" type="xs:string"
                   form="unqualified"/>
     <xs:attribute name="DestinationDatabase" type="xs:string"
                   form="unqualified"/>
     <xs:attribute name="CopyAllObjects" type="xs:boolean"
                   form="unqualified"/>
     <xs:attribute name="CopyAllRules" type="xs:boolean"
                   form="unqualified"/>
     <xs:attribute name="CopyAllTables" type="xs:boolean"
                   form="unqualified"/>
     <xs:attribute name="CopyAllViews" type="xs:boolean"
                   form="unqualified"/>
     <xs:attribute name="CopyAllStoredProcedures"
                   type="xs:boolean" form="unqualified"/>
     <xs:attribute name="CopyAllUserDefinedFunctions"
                   type="xs:boolean" form="unqualified"/>
     <xs:attribute name="CopyAllDefaults" type="xs:boolean"
                   form="unqualified"/>
     <xs:attribute name="CopyAllUserDefinedDataTypes"
                   type="xs:boolean" form="unqualified"/>
     <xs:attribute name="CopyAllPartitionFunctions" type="xs:boolean"
                   form="unqualified"/>
     <xs:attribute name="CopyAllPartitionSchemes" type="xs:boolean"
                   form="unqualified"/>
     <xs:attribute name="CopyAllSchemas" type="xs:boolean"
                   form="unqualified"/>
     <xs:attribute name="CopyAllSqlAssemblies" type="xs:boolean"
                   form="unqualified"/>
     <xs:attribute name="CopyAllUserDefinedAggregates"
                   type="xs:boolean" form="unqualified"/>
     <xs:attribute name="CopyAllUserDefinedTypes" type="xs:boolean"
                   form="unqualified"/>
     <xs:attribute name="CopyAllXmlSchemaCollections" type="xs:boolean"
                   form="unqualified"/>
     <xs:attribute name="LoginsList" type="xs:string"
                   form="unqualified"/>
     <xs:attribute name="UsersList" type="xs:string"
                   form="unqualified"/>
     <xs:attribute name="RulesList" type="xs:string"
                   form="unqualified"/>
     <xs:attribute name="TablesList" type="xs:string"
                   form="unqualified"/>
     <xs:attribute name="ViewsList" type="xs:string"
                   form="unqualified"/>
     <xs:attribute name="StoredProceduresList"
                   type="xs:string" form="unqualified"/>
     <xs:attribute name="UserDefinedFunctionsList"
                   type="xs:string" form="unqualified"/>
     <xs:attribute name="DefaultsList" type="xs:string"
                   form="unqualified"/>
     <xs:attribute name="UserDefinedDataTypesList"
                   type="xs:string" form="unqualified"/>
     <xs:attribute name="PartitionFunctionsList" type="xs:string"
                   form="unqualified"/>
     <xs:attribute name="PartitionSchemesList" type="xs:string"
                   form="unqualified"/>
     <xs:attribute name="SchemasList" type="xs:string"
                   form="unqualified"/>
     <xs:attribute name="SqlAssembliesList" type="xs:string"
                   form="unqualified"/>
     <xs:attribute name="UserDefinedAggregatesList"
                   type="xs:string" form="unqualified"/>
     <xs:attribute name="UserDefinedTypesList" type="xs:string"
                   form="unqualified"/>
     <xs:attribute name="XmlSchemaCollectionsList" type="xs:string"
                   form="unqualified"/>
     <xs:attribute name="DropObjectsFirst" type="xs:boolean"
                   form="unqualified"/>
     <xs:attribute name="IncludeDependentObjects"
                   type="xs:boolean" form="unqualified"/>
     <xs:attribute name="IncludeExtendedProperties" type="xs:boolean"
                   form="unqualified"/>
     <xs:attribute name="CopyData" type="xs:boolean"
                   form="unqualified"/>
     <xs:attribute name="ExistingData"
         type="DTS:TransferSqlServerObjectsTaskExistingDataEnum"
                   form="unqualified"/>
     <xs:attribute name="CopySchema" type="xs:boolean"
                   form="unqualified"/>
     <xs:attribute name="UseCollation" type="xs:boolean"
                   form="unqualified"/>
     <xs:attribute name="CopyDatabaseUsers" type="xs:boolean"
                   form="unqualified"/>
     <xs:attribute name="CopyDatabaseRoles" type="xs:boolean"
                   form="unqualified"/>
     <xs:attribute name="CopySqlServerLogins" type="xs:boolean"
                   form="unqualified"/>
     <xs:attribute name="CopyObjectLevelPermissions" type="xs:boolean"
                   form="unqualified"/>
     <xs:attribute name="CopyIndexes" type="xs:boolean"
                   form="unqualified"/>
     <xs:attribute name="CopyTriggers" type="xs:boolean"
                   form="unqualified"/>
     <xs:attribute name="CopyFullTextIndexes" type="xs:boolean"
                   form="unqualified"/>
     <xs:attribute name="CopyPrimaryKeys" type="xs:boolean"
                   form="unqualified"/>
     <xs:attribute name="CopyForeignKeys" type="xs:boolean"
                   form="unqualified"/>
     <xs:attribute name="GenerateScriptsInUnicode" type="xs:boolean"
                   form="unqualified"/>
     <xs:attribute name="SourceTranslateChar" type="xs:boolean"
                   form="unqualified"/>
     <xs:attribute name="DestinationTranslateChar" type="xs:boolean"
                   form="unqualified"/>
     <xs:attribute name="CopyAllDRIObjects" type="xs:boolean"
                   form="unqualified"/>
   </xs:complexType>

The TransferSqlServerObjectsTaskDataObjectDataType complex type MUST NOT contain any elements or values.

The following table specifies the attributes of the TransferSqlServerObjectsTaskDataObjectDataType complex type.

Attribute

Description

SourceConnection

A string value that specifies a reference to the connection manager for the source of the data to be transferred. The connection manager can be referenced by its DTSID property or by its ObjectName property.

DestinationConnection

A string value that specifies a reference to the connection manager for the destination of the data to be transferred. The connection manager can be referenced by its DTSID property or by its ObjectName property.

SourceDatabase

A string value that specifies the source database for objects to be transferred.

DestinationDatabase

A string value that specifies the destination database for objects to be transferred.

CopyAllObjects

A Boolean value that specifies whether the task copies all objects or only the specified objects.

TRUE specifies that all objects from the source database are copied.

FALSE specifies that only the specified objects are copied.

CopyAllRules

A Boolean value that specifies whether the task copies all rule objects or only the specified rule objects.

TRUE specifies that all rule objects from the source database are copied.

FALSE specifies that only the rules that are specified in the RulesList attribute are copied.

CopyAllTables

A Boolean value that specifies whether the task copies all tables or only the specified tables.

TRUE specifies that all tables from the source database are copied.

FALSE specifies that only the tables that are specified in the TablesList attribute are copied.

CopyAllViews

A Boolean value that specifies whether the task copies all views or only the specified views.

TRUE specifies that all views from the source database are copied.

FALSE specifies that only the views that are specified in the ViewsList attribute are copied.

CopyAllStoredProcedures

A Boolean value that specifies whether the task copies all stored procedures or only the specified stored procedures.

TRUE specifies that all stored procedures from the source database are copied.

FALSE specifies that only the stored procedures specified in the StoredProceduresList attribute are copied.

CopyAllUserDefinedFunctions

A Boolean value that specifies whether the task copies all user-defined functions or only the specified user-defined functions.

TRUE specifies that all user-defined functions from the source database are copied.

FALSE specifies that only the user-defined functions that are specified in the UserDefinedFunctionsList attribute are copied.

CopyAllDefaults

A Boolean value that specifies whether the task copies all defaults or only the specified defaults.

TRUE specifies that all defaults from the source database are copied.

FALSE specifies that only the defaults specified in the DefaultsList attribute are copied.

CopyAllUserDefinedDataTypes

A Boolean value that specifies whether the task copies all user-defined data types or only the specified user-defined data types.

TRUE specifies that all user-defined data types from the source database are copied.

FALSE specifies that only the user-defined data types specified in the UserDefinedTypesList attribute are copied.

CopyAllPartitionFunctions

A Boolean value that specifies whether the task copies all partition functions or only the specified partition functions.

TRUE specifies that all partition functions from the source database are copied.

FALSE specifies that only the defaults specified in the PartitionFunctionsList attribute are copied.

CopyAllPartitionSchemas

A Boolean value that specifies whether the task copies all partition schemas or only the specified partition schemas.

TRUE specifies that all partition schemas from the source database are copied.

FALSE specifies that only the partition schemas specified in the PartitionSchemesList attribute are copied.

CopyAllSchemas

A Boolean value that specifies whether the task copies all schemas or only the specified schemas.

TRUE specifies that all schemas from the source database are copied.

FALSE specifies that only the schemas specified in the SchemasList attribute are copied.

CopyAllSqlAssemblies

A Boolean value that specifies whether the task copies all SQL assemblies or only the specified SQL assemblies.

TRUE specifies that all SQL assemblies from the source database are copied.

FALSE specifies that only the SQL assemblies specified in the SqlAssembliesList attribute are copied.

CopyAllUserDefinedAggregates

A Boolean value that specifies whether the task copies all user-defined aggregates or only the specified user-defined aggregates.

TRUE specifies that all user-defined aggregates from the source database are copied.

FALSE specifies that only the user-defined aggregates specified in the UserDefinedAggregatesList attribute are copied.

CopyAllUserDefinedTypes

A Boolean value that specifies whether the task copies all user-defined types or only the specified user-defined types.

TRUE specifies that all user-defined types from the source database are copied.

FALSE specifies that only the user-defined types that are specified in the UserDefinedTypesList attribute are copied.

CopyAllXmlSchemaCollections

A Boolean value that specifies whether the task copies all XML schema collections or only the specified XML schema collections.

TRUE specifies that all XML schema collections from the source database are copied.

FALSE specifies that only the XML schema collections that are specified in the XmlSchemaCollectionsList attribute are copied.

LoginsList

A string value that specifies the list of logins to copy.

UsersList

A string value that specifies the list of database users to copy.

RulesList

A string value that specifies the list of rules to copy.

TablesList

A string value that specifies the list of tables to copy.

ViewsList

A string value that specifies the list of views to copy.

StoredProceduresList

A string value that specifies the list of stored procedures to copy.

UserDefinedFunctionsList

A string value that specifies the list of user-defined functions to copy.

DefaultsList

A string value that specifies the list of defaults to copy.

UserDefinedDataTypesList

A string value that specifies the list of user-defined data types to copy.

PartitionFunctionsList

A string value that specifies the list of partition functions to copy.

PartitionSchemesList

A string value that specifies the list of partition schemas to copy.

SchemasList

A string value that specifies the list of schemas to copy.

SqlAssembliesList

A string value that specifies the list of SQL assemblies to copy.

UserDefinedAggregatesList

A string value that specifies the list of user-defined aggregates to copy.

UserDefinedTypesList

A string value that specifies the list of user-defined types to copy.

XmlSchemaCollectionsList

A string value that specifies the list of XML schema collections to copy.

DropObjectsFirst

A Boolean value that specifies whether to drop object on the destination database before the transfer. This option is used only if the value of the CopySchema attribute is set to TRUE.

TRUE specifies that objects on the destination server are dropped before the transfer.

FALSE specifies that objects on the destination server are not dropped before the transfer.

IncludeDependentObjects

A Boolean value that specifies whether dependent objects are included with the transfer.

TRUE specifies that dependent objects are included with the transfer.

FALSE specifies that dependent objects are not included with the transfer.

IncludeExtendedProperties

A Boolean value that specifies whether extended properties are included with the transfer.

TRUE specifies that extended properties are included with the transfer.

FALSE specifies that extended properties are not included with the transfer.

CopyData

A Boolean value that specifies whether data is included with the transfer.

TRUE specifies that data is included with the transfer.

FALSE specifies that data is not included with the transfer.

ExistingData

An enumeration value that specifies whether to append or replace existing data. This value is used only if the CopyData attribute is set to TRUE and the DropObjectsFirst attribute is set to FALSE.

CopySchema

A Boolean value that specifies whether the schema is included with the transfer.

TRUE specifies that the schema is included with the transfer.

FALSE specifies that the schema is not included with the transfer.

UseCollation

A Boolean value that specifies whether the transfer includes a collation.

TRUE specifies that a collation is included with the transfer.

FALSE specifies that a collation is not included with the transfer.

CopyDatabaseUsers

A Boolean value that specifies whether database users are included in the transfer.

TRUE specifies that database users are included with the transfer. The database users that are specified in the UsersList attribute are copied.

FALSE specifies that database users are not included with the transfer.

CopyDatabaseRoles

A Boolean value that specifies whether database roles are included in the transfer.

TRUE specifies that database roles are included with the transfer.

FALSE specifies that database roles are not included with the transfer.

CopySqlServerLogins

A Boolean value that specifies whether database logins<92> are included in the transfer.

TRUE specifies that database logins are included with the transfer.

FALSE specifies that database logins are not included with the transfer.

CopyObjectLevelPermissions

A Boolean value that specifies whether object-level permissions are included in the transfer.

TRUE specifies that object-level permissions are included with the transfer.

FALSE specifies that object level permissions are not included with the transfer.

CopyIndexes

A Boolean value that specifies whether indexes are included in the transfer.

TRUE specifies that indexes are included in the transfer.

FALSE specifies that indexes are not included in the transfer.

CopyTriggers

A Boolean value that specifies whether triggers are included in the transfer.

TRUE specifies that triggers are included in the transfer.

FALSE specifies that triggers are not included in the transfer.

CopyFullTextIndexes

A Boolean value that specifies whether indexes are included in the transfer.

TRUE specifies that triggers are included in the transfer.

FALSE specifies that triggers are not included in the transfer.

CopyPrimaryKeys

A Boolean value that specifies whether primary key constraints are included in the transfer.

TRUE specifies that primary key constraints are included in the transfer.

FALSE specifies that primary key constraints are not included in the transfer.

CopyForeignKeys

A Boolean value that specifies whether foreign key constraints are included in the transfer.

TRUE specifies that foreign key constraints are included in the transfer.

FALSE specifies that foreign key constraints are not included in the transfer.

GenerateScriptsInUnicode

A Boolean value that specifies whether the script MUST be generated in Unicode format.

TRUE specifies that the script MUST be generated in Unicode format.

FALSE specifies that the script MUST NOT be generated in Unicode format.

SourceTranslateChar

A Boolean value that specifies whether the transfer operation translates the codepage for characters on the source database.

TRUE specifies that the transfer operation translates the codepage for characters on the source database.

FALSE specifies that the transfer operation does not translate the codepage for characters on the source database.

DestinationTranslateChar

A Boolean value that specifies whether the transfer operation translates the codepage for characters on the destination database.

TRUE specifies that the transfer operation translates the codepage for characters on the destination database.

FALSE specifies that the transfer operation does not translate the codepage for characters on the destination database.

CopyAllDRIObjects

A Boolean value that specifies data referential integrity (DRI) objects are included in the transfer.

TRUE specifies that DRI objects are included in the transfer.

FALSE specifies that DRI objects are not included in the transfer.