Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Transfer Class

The Transfer object is a tool object that provides programmatic control over copying of schemas and data to other instances of SQL Server.

System.Object
  Microsoft.SqlServer.Management.Smo.Transfer

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.SmoExtended (in Microsoft.SqlServer.SmoExtended.dll)
public class Transfer : ITransferMetadataProvider

The Transfer type exposes the following members.

  NameDescription
Public methodTransfer()Initializes a new instance of the Transfer class.
Public methodTransfer(Database)Initializes a new instance of the Transfer class that uses the specified database as the source of the transfer operation.
Top
  NameDescription
Public propertyCopyAllDatabaseTriggersGets or sets the Boolean property value that specifies whether all the SQL Server database triggers are copied from the source database to the target database in the transfer operation.
Public propertyCopyAllDefaultsGets or sets the Boolean property value that specifies whether all the SQL Server defaults are copied from the source database to the target database in the transfer operation.
Public propertyCopyAllFullTextCatalogsGets or sets the Boolean property value that specifies whether all the SQL Server Full-Text catalogs are copied from the source database to the target database in the transfer operation.
Public propertyCopyAllFullTextStopListsGets or sets the Boolean property value that specifies whether all the SQL Server full-text stop lists are copied from the source database to the target database in the transfer operation.
Public propertyCopyAllLoginsGets or sets the Boolean property value that specifies whether all the SQL Server logins are copied from the source database to the target database in the transfer operation.
Public propertyCopyAllObjectsGets or sets the Boolean property value that specifies whether all the SQL Server objects are copied from the source database to the target database in the transfer operation.
Public propertyCopyAllPartitionFunctionsGets or sets the Boolean property value that specifies whether all the SQL Server partition functions are copied from the source database to the target database in the transfer operation.
Public propertyCopyAllPartitionSchemesGets or sets the Boolean property value that specifies whether all the SQL Server partition schemes are copied from the source database to the target database in the transfer operation.
Public propertyCopyAllPlanGuidesGets or sets the Boolean property value that specifies whether all the SQL Server plan guides are copied from the source database to the target database in the transfer operation.
Public propertyCopyAllRolesGets or sets the Boolean property value that specifies whether all the SQL Server roles are copied from the source database to the target database in the transfer operation.
Public propertyCopyAllRulesGets or sets the Boolean property value that specifies whether all the SQL Server rules are copied from the source database to the target database in the transfer operation.
Public propertyCopyAllSchemasGets or sets the Boolean property value that specifies whether all the SQL Server schemas are copied from the source database to the target database in the transfer operation.
Public propertyCopyAllSqlAssembliesGets or sets the Boolean property value that specifies whether all the SQL Server assemblies are copied from the source database to the target database in the transfer operation.
Public propertyCopyAllStoredProceduresGets or sets the Boolean property value that specifies whether all the SQL Server stored procedures are copied from the source database to the target database in the transfer operation.
Public propertyCopyAllSynonymsGets or sets the Boolean property value that specifies whether all the SQL Server synonyms are copied from the source database to the target database in the transfer operation.
Public propertyCopyAllTablesGets or sets the Boolean property value that specifies whether all the SQL Server tables are copied from the source database to the target database in the transfer operation.
Public propertyCopyAllUserDefinedAggregatesGets or sets the Boolean property value that specifies whether all the SQL Server user-defined aggregates are copied from the source database to the target database in the transfer operation.
Public propertyCopyAllUserDefinedDataTypesGets or sets the Boolean property value that specifies whether all the SQL Server user-defined data types are copied from the source database to the target database in the transfer operation.
Public propertyCopyAllUserDefinedFunctionsGets or sets the Boolean property value that specifies whether all the SQL Server user-defined functions are copied from the source database to the target database in the transfer operation.
Public propertyCopyAllUserDefinedTableTypesGets or sets the Boolean property value that specifies whether all the SQL Server user-defined table types are copied from the source database to the target database in the transfer operation.
Public propertyCopyAllUserDefinedTypesGets or sets the Boolean property value that specifies whether all the SQL Server user-defined types are copied from the source database to the target database in the transfer operation.
Public propertyCopyAllUsersGets or sets the Boolean property value that specifies whether all the SQL Server database users are copied from the source database to the target database in the transfer operation.
Public propertyCopyAllViewsGets or sets the Boolean property value that specifies whether all the SQL Server views are copied from the source database to the target database in the transfer operation.
Public propertyCopyAllXmlSchemaCollectionsGets or sets the Boolean property value that specifies whether all the SQL Server XML schema collections are copied from the source database to the target database in the transfer operation.
Public propertyCopyDataGets or sets the Boolean property value that specifies whether all the data is copied from the source database to the target database in the transfer operation.
Public propertyCopySchemaGets or sets the Boolean property value that specifies whether the schema is copied from the source database to the target database in the transfer operation.
Public propertyCreateTargetDatabaseGets or sets the Boolean property value that specifies whether the target database is created in the transfer operation.
Public propertyDatabaseGets or sets the database from which schema or data is to be transferred to the target location.
Public propertyDatabaseFileMappingsGets or sets properties that are associated with flat file destination based on a DatabaseFileMappingsDictionary object.
Public propertyDestinationDatabaseGets or sets the database that is the destination of the transfer operation.
Public propertyDestinationLoginGets or sets the logon for the instance of SQL Server to which the destination database belongs.
Public propertyDestinationLoginSecureGets or sets the Boolean property that specifies whether the instance of SQL Server that contains the destination database is enabled for Windows Authentication or not.
Public propertyDestinationPasswordGets or sets the logon password for the instance of SQL Server to which the destination database belongs.
Public propertyDestinationServerGets or sets the instance of SQL Server that owns the database that is the destination of the transfer operation.
Public propertyDestinationTranslateCharGets or sets the Boolean property value that specifies whether the transfer operation translates the code page for characters on the destination database.
Public propertyDropDestinationObjectsFirstGets or sets the Boolean property value that specifies whether to drop the objects in the destination database before the transfer operation.
Public propertyObjectListGets or sets the objects copied from the source to destination in the transfer operation.
Public propertyOptionsGets or sets the options for the transfer operation.
Public propertyPrefetchObjectsGets or sets the Boolean property that specifies whether to prefetch the objects before the transfer operation.
Public propertyPreserveDboGets or sets a Boolean value that specifies whether DBO ownerships are retained through the transfer process.
Public propertyPreserveLoginsGets or sets the Boolean property that specifies whether to preserve logins in the transfer operation.
Public propertySourceTranslateCharGets or sets the Boolean property value that specifies whether the transfer operation translates the code page for characters on the source database.
Public propertyTargetDatabaseFilePathGets or sets the path to where the database files will be copied.
Public propertyTargetLogFilePathGets or sets the path to where the database files will be copied.
Public propertyTemporaryPackageDirectoryGets or sets the file location for storage of temporary packages created during the transfer operation.
Public propertyUseDestinationTransactionGets or sets the Boolean property value that specifies whether to use the destination transaction.
Top
  NameDescription
Public methodEnumObjectsReturns an enumerated list of Uniform Resource Name (URN) values that represent the objects included in the transfer operation.
Public methodEnumScriptTransferCreates a Transact-SQL command batch script used to transfer database objects or database objects and data to another database instance.
Public methodEquals (Inherited from Object.)
Protected methodFinalize (Inherited from Object.)
Public methodGetHashCode (Inherited from Object.)
Public methodGetTransferProviderReturns the data transfer provider interface.
Public methodGetType (Inherited from Object.)
Protected methodMemberwiseClone (Inherited from Object.)
Protected methodStatic memberProcessDependencyChainReturns a URN array with options.
Public methodScriptTransferCreates a Transact-SQL command batch script that creates database objects that are transferred by the transfer operation.
Public methodToString (Inherited from Object.)
Public methodTransferDataTransfers data as specified by the Transfer object.
Top
  NameDescription
Public eventDataTransferEventReports that data has been transferred.
Public eventDiscoveryProgressMarks the progress of the discovery process.
Public eventScriptingErrorReports that an error occurred during the scripting process.
Public eventScriptingProgressMarks the progress of the scripting process.
Top
  NameDescription
Explicit interface implemetationPrivate methodITransferMetadataProvider.GetOptionsThe ITransferMetadataProvider class represents an interface that implements the transfer metadata process on the referenced connection.
Explicit interface implemetationPrivate methodITransferMetadataProvider.SaveMetadataSaves metadata when transferring databases across instances.
Top

There are some limitations when transferring a database to a server instance that is running SQL Server 2000: 

  • If the database has a schema for which there is no corresponding user on the target SQL Server 2000 server instance, it cannot be transferred. In this case, you have to create a user who has a name that is the same as the name of the schema.

  • Any object that uses the following data types cannot be transferred:

    • SqlDataType.Xml

    • SqlDataType.VarCharMax

    • SqlDataType.NVarCharMax

    • SqlDataType.VarBinaryMax

The following object types cannot be transferred:

  • All broker objects

  • All mail objects

  • Endpoint

  • ServerDdlTrigger

  • ExtendedStoredProcedure

  • FullTextCatalog

  • UserDefinedMessage

  • ApplicationRole

To get and set Transfer object properties, users can be a member of the public fixed server role.

To transfer data, users can be a member of the public fixed server role.

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are safe for multithreaded operations. Any instance members are not guaranteed to be thread safe. 

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

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.