Transfer Class
TOC
Collapse the table of content
Expand the table of content

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.

Namespace:   Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.SmoExtended (in Microsoft.SqlServer.SmoExtended.dll)


public class Transfer : DataTransferBase, ITransferMetadataProvider

NameDescription
System_CAPS_pubmethodTransfer()

Initializes a new instance of the Transfer class.

System_CAPS_pubmethodTransfer(Database)

Initializes a new instance of the Transfer class that uses the specified database as the source of the transfer operation.

NameDescription
System_CAPS_pubpropertyBatchSize

Gets or sets the batch size property.

System_CAPS_pubpropertyBulkCopyTimeout

Gets or sets the operation to complete before it times out.

System_CAPS_pubpropertyCopyAllDatabaseTriggers

Gets or sets a value that indicates whether all the SQL Server database triggers are copied from the source database to the target database in the transfer operation.(Inherited from TransferBase.)

System_CAPS_pubpropertyCopyAllDefaults

Gets or sets a value that indicates whether all the SQL Server defaults are copied from the source database to the target database in the transfer operation.(Inherited from TransferBase.)

System_CAPS_pubpropertyCopyAllFullTextCatalogs

Gets or sets a value that indicates whether all the SQL Server full-text catalogs are copied from the source database to the target database in the transfer operation.(Inherited from TransferBase.)

System_CAPS_pubpropertyCopyAllFullTextStopLists

Gets or sets a value that indicates whether all the SQL Server full-text stop lists are copied from the source database to the target database in the transfer operation.(Inherited from TransferBase.)

System_CAPS_pubpropertyCopyAllLogins

Gets or sets a value that indicates whether all the SQL Server logins are copied from the source database to the target database in the transfer operation.(Inherited from TransferBase.)

System_CAPS_pubpropertyCopyAllObjects

Gets or sets a value that indicates whether all the SQL Server objects are copied from the source database to the target database in the transfer operation.(Inherited from TransferBase.)

System_CAPS_pubpropertyCopyAllPartitionFunctions

Gets or sets a value that indicates whether all the SQL Server partition functions are copied from the source database to the target database in the transfer operation.(Inherited from TransferBase.)

System_CAPS_pubpropertyCopyAllPartitionSchemes

Gets or sets a value that indicates whether all the SQL Server partition schemes are copied from the source database to the target database in the transfer operation.(Inherited from TransferBase.)

System_CAPS_pubpropertyCopyAllPlanGuides

Gets or sets a value that indicates whether all the SQL Server plan guides are copied from the source database to the target database in the transfer operation.(Inherited from TransferBase.)

System_CAPS_pubpropertyCopyAllRoles

Gets or sets a value that indicates whether all the SQL Server roles are copied from the source database to the target database in the transfer operation.(Inherited from TransferBase.)

System_CAPS_pubpropertyCopyAllRules

Gets or sets a value that indicates whether all the SQL Server rules are copied from the source database to the target database in the transfer operation.(Inherited from TransferBase.)

System_CAPS_pubpropertyCopyAllSchemas

Gets or sets a value that indicates whether all the SQL Server schemas are copied from the source database to the target database in the transfer operation.(Inherited from TransferBase.)

System_CAPS_pubpropertyCopyAllSearchPropertyLists

Gets or sets a value that indicates whether all the SQL Server search property lists are copied from the source database to the target database in the transfer operation.(Inherited from TransferBase.)

System_CAPS_pubpropertyCopyAllSequences

Gets or sets a value that indicates whether all the SQL Server sequences are copied from the source database to the target database in the transfer operation.(Inherited from TransferBase.)

System_CAPS_pubpropertyCopyAllSqlAssemblies

Gets or sets a value that indicates whether all the SQL Server assemblies are copied from the source database to the target database in the transfer operation.(Inherited from TransferBase.)

System_CAPS_pubpropertyCopyAllStoredProcedures

Gets or sets a value that indicates whether all the SQL Server stored procedures are copied from the source database to the target database in the transfer operation.(Inherited from TransferBase.)

System_CAPS_pubpropertyCopyAllSynonyms

Gets or sets a value that indicates whether all the SQL Server synonyms are copied from the source database to the target database in the transfer operation.(Inherited from TransferBase.)

System_CAPS_pubpropertyCopyAllTables

Gets or sets a value that indicates whether all the SQL Server tables are copied from the source database to the target database in the transfer operation.(Inherited from TransferBase.)

System_CAPS_pubpropertyCopyAllUserDefinedAggregates

Gets or sets a value that indicates whether all the SQL Server user-defined aggregates are copied from the source database to the target database in the transfer operation.(Inherited from TransferBase.)

System_CAPS_pubpropertyCopyAllUserDefinedDataTypes

Gets or sets a value that indicates whether all the SQL Server user-defined data types are copied from the source database to the target database in the transfer operation.(Inherited from TransferBase.)

System_CAPS_pubpropertyCopyAllUserDefinedFunctions

Gets or sets a value that indicates whether all the SQL Server user-defined functions are copied from the source database to the target database in the transfer operation.(Inherited from TransferBase.)

System_CAPS_pubpropertyCopyAllUserDefinedTableTypes

Gets or sets a value that indicates whether all the SQL Server user-defined table types are copied from the source database to the target database in the transfer operation.(Inherited from TransferBase.)

System_CAPS_pubpropertyCopyAllUserDefinedTypes

Gets or sets a value that indicates whether all the SQL Server user-defined types are copied from the source database to the target database in the transfer operation.(Inherited from TransferBase.)

System_CAPS_pubpropertyCopyAllUsers

Gets or sets a value that indicates whether all the SQL Server database users are copied from the source database to the target database in the transfer operation.(Inherited from TransferBase.)

System_CAPS_pubpropertyCopyAllViews

Gets or sets a value that indicates whether all the SQL Server views are copied from the source database to the target database in the transfer operation.(Inherited from TransferBase.)

System_CAPS_pubpropertyCopyAllXmlSchemaCollections

Gets or sets a value that indicates whether all the SQL Server XML schema collections are copied from the source database to the target database in the transfer operation.(Inherited from TransferBase.)

System_CAPS_pubpropertyCopyData

Gets or sets a value that indicates whether all the data is copied from the source database to the target database in the transfer operation.(Inherited from TransferBase.)

System_CAPS_pubpropertyCopySchema

Gets or sets a value that indicates whether the schema is copied from the source database to the target database in the transfer operation.(Inherited from TransferBase.)

System_CAPS_pubpropertyCreateTargetDatabase

Gets or sets a value that indicates whether the target database is created in the transfer operation.(Inherited from TransferBase.)

System_CAPS_pubpropertyDatabase

Gets or sets the database from which schema or data is to be transferred to the target location.(Inherited from TransferBase.)

System_CAPS_pubpropertyDatabaseFileMappings

Gets or sets the properties that are associated with flat file destination based on a dictionary.(Inherited from TransferBase.)

System_CAPS_pubpropertyDestinationDatabase

Gets or sets the database that is the destination of the transfer operation.(Inherited from TransferBase.)

System_CAPS_pubpropertyDestinationLogin

Gets or sets the logon for the instance of SQL Server to which the destination database belongs.(Inherited from TransferBase.)

System_CAPS_pubpropertyDestinationLoginSecure

Gets or sets a value that indicates whether the instance of SQL Server that contains the destination database is enabled for Windows Authentication or not.(Inherited from TransferBase.)

System_CAPS_pubpropertyDestinationPassword

Gets or sets the logon password for the instance of SQL Server to which the destination database belongs.(Inherited from TransferBase.)

System_CAPS_pubpropertyDestinationServer

Gets or sets the instance of SQL Server that owns the database that is the destination of the transfer operation.(Inherited from TransferBase.)

System_CAPS_pubpropertyDestinationTranslateChar

Gets or sets a value that indicates whether the transfer operation translates the code page for characters on the destination database.(Inherited from TransferBase.)

System_CAPS_pubpropertyDropDestinationObjectsFirst

Gets or sets a value that indicates whether to drop the objects in the destination database before the transfer operation.(Inherited from TransferBase.)

System_CAPS_pubpropertyObjectList

Gets or sets the objects copied from the source to destination in the transfer operation.(Inherited from TransferBase.)

System_CAPS_pubpropertyOptions

Gets or sets the options for the transfer operation.(Inherited from TransferBase.)

System_CAPS_pubpropertyPrefetchObjects

Gets or sets a value that indicates whether to prefetch the objects before the transfer operation.(Inherited from TransferBase.)

System_CAPS_pubpropertyPreserveDbo

Gets or sets a value that indicates whether DBO ownerships are retained through the transfer process.(Inherited from TransferBase.)

System_CAPS_pubpropertyPreserveLogins

Gets or sets a value that indicates whether to preserve logins in the transfer operation.(Inherited from TransferBase.)

System_CAPS_protpropertyScripter

Gets the scripter for the transfer operation.(Inherited from TransferBase.)

System_CAPS_pubpropertySourceTranslateChar

Gets or sets a value that indicates whether the transfer operation translates the code page for characters on the source database.(Inherited from TransferBase.)

System_CAPS_pubpropertyTargetDatabaseFilePath

Gets or sets the path to where the database files will be copied.(Inherited from TransferBase.)

System_CAPS_pubpropertyTargetLogFilePath

Gets or sets the path to where the log files will be copied.(Inherited from TransferBase.)

System_CAPS_pubpropertyTemporaryPackageDirectory

For internal use only. The value of this property is ignored if set by a caller.

System_CAPS_pubpropertyUseDestinationTransaction

Gets or sets a value that indicates whether to use the destination transaction.(Inherited from TransferBase.)

NameDescription
System_CAPS_pubmethodEnumObjects()

Returns an enumerated list of Uniform Resource Name (URN) values that represent the objects included in the transfer operation.(Inherited from TransferBase.)

System_CAPS_pubmethodEnumScriptTransfer()

Creates a Transact-SQL command batch script used to transfer database objects or database objects and data to another database instance.(Inherited from TransferBase.)

System_CAPS_pubmethodEquals(Object)

(Inherited from Object.)

System_CAPS_protmethodFinalize()

(Inherited from Object.)

System_CAPS_pubmethodGetHashCode()

(Inherited from Object.)

System_CAPS_pubmethodGetTransferProvider()

For internal use only. Throws a System.NotSupportedException if invoked by a caller.

System_CAPS_pubmethodGetType()

(Inherited from Object.)

System_CAPS_protmethodMemberwiseClone()

(Inherited from Object.)

System_CAPS_protmethodSystem_CAPS_staticProcessDependencyChain(Server, DependencyChainCollection, Boolean, Boolean)

Returns a URN array with options.

System_CAPS_pubmethodScriptTransfer()

Creates a Transact-SQL command batch script that creates database objects that are transferred by the transfer operation.(Inherited from TransferBase.)

System_CAPS_protmethodSetTargetServerInfo()

Sets the target server version based on the SQL Server version.(Inherited from TransferBase.)

System_CAPS_pubmethodToString()

(Inherited from Object.)

System_CAPS_pubmethodTransferData()

Transfers data as specified by the Transfer object.

NameDescription
System_CAPS_pubeventDataTransferEvent

Reports that data has been transferred.

System_CAPS_pubeventDiscoveryProgress

Marks the progress of the discovery process.(Inherited from TransferBase.)

System_CAPS_pubeventScriptingError

Reports that an error occurred during the scripting process.(Inherited from TransferBase.)

System_CAPS_pubeventScriptingProgress

Marks the progress of the scripting process.(Inherited from TransferBase.)

NameDescription
System_CAPS_pubinterfaceSystem_CAPS_privmethodITransferMetadataProvider.GetOptions()

The ITransferMetadataProvider class represents an interface that implements the transfer metadata process on the referenced connection.

System_CAPS_pubinterfaceSystem_CAPS_privmethodITransferMetadataProvider.SaveMetadata()

Saves metadata when transferring databases across instances.

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.

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.  

Legacy Code Example

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:
© 2016 Microsoft