Transfer Transfer Transfer Class

Definition

Instance class encapsulating Transfer object

public class Transfer : Microsoft.SqlServer.Management.Smo.DataTransferBase, Microsoft.SqlServer.Management.Common.ITransferMetadataProvider
type Transfer = class
    inherit DataTransferBase
    interface ITransferMetadataProvider
Public Class Transfer
Inherits DataTransferBase
Implements ITransferMetadataProvider
Inheritance
Implements

Constructors

Transfer() Transfer() Transfer()
Transfer(Database) Transfer(Database) Transfer(Database)

Properties

BatchSize BatchSize BatchSize

Number of rows in each batch of SqlBulkCopy. At the end of each batch, the rows in the batch are sent to the server.

BulkCopyTimeout BulkCopyTimeout BulkCopyTimeout

Number of seconds for the operation to complete before SqlBulkCopy times out.

CopyAllDatabaseScopedCredentials CopyAllDatabaseScopedCredentials CopyAllDatabaseScopedCredentials Inherited from TransferBase
CopyAllDatabaseTriggers CopyAllDatabaseTriggers CopyAllDatabaseTriggers Inherited from TransferBase
CopyAllDefaults CopyAllDefaults CopyAllDefaults Inherited from TransferBase
CopyAllExternalDataSources CopyAllExternalDataSources CopyAllExternalDataSources Inherited from TransferBase
CopyAllExternalFileFormats CopyAllExternalFileFormats CopyAllExternalFileFormats Inherited from TransferBase
CopyAllExternalLibraries CopyAllExternalLibraries CopyAllExternalLibraries Inherited from TransferBase
CopyAllFullTextCatalogs CopyAllFullTextCatalogs CopyAllFullTextCatalogs Inherited from TransferBase
CopyAllFullTextStopLists CopyAllFullTextStopLists CopyAllFullTextStopLists Inherited from TransferBase
CopyAllLogins CopyAllLogins CopyAllLogins Inherited from TransferBase
CopyAllObjects CopyAllObjects CopyAllObjects Inherited from TransferBase
CopyAllPartitionFunctions CopyAllPartitionFunctions CopyAllPartitionFunctions Inherited from TransferBase
CopyAllPartitionSchemes CopyAllPartitionSchemes CopyAllPartitionSchemes Inherited from TransferBase
CopyAllPlanGuides CopyAllPlanGuides CopyAllPlanGuides Inherited from TransferBase
CopyAllRoles CopyAllRoles CopyAllRoles Inherited from TransferBase
CopyAllRules CopyAllRules CopyAllRules Inherited from TransferBase
CopyAllSchemas CopyAllSchemas CopyAllSchemas Inherited from TransferBase
CopyAllSearchPropertyLists CopyAllSearchPropertyLists CopyAllSearchPropertyLists Inherited from TransferBase
CopyAllSequences CopyAllSequences CopyAllSequences Inherited from TransferBase
CopyAllSqlAssemblies CopyAllSqlAssemblies CopyAllSqlAssemblies Inherited from TransferBase
CopyAllStoredProcedures CopyAllStoredProcedures CopyAllStoredProcedures Inherited from TransferBase
CopyAllSynonyms CopyAllSynonyms CopyAllSynonyms Inherited from TransferBase
CopyAllTables CopyAllTables CopyAllTables Inherited from TransferBase
CopyAllUserDefinedAggregates CopyAllUserDefinedAggregates CopyAllUserDefinedAggregates Inherited from TransferBase
CopyAllUserDefinedDataTypes CopyAllUserDefinedDataTypes CopyAllUserDefinedDataTypes Inherited from TransferBase
CopyAllUserDefinedFunctions CopyAllUserDefinedFunctions CopyAllUserDefinedFunctions Inherited from TransferBase
CopyAllUserDefinedTableTypes CopyAllUserDefinedTableTypes CopyAllUserDefinedTableTypes Inherited from TransferBase
CopyAllUserDefinedTypes CopyAllUserDefinedTypes CopyAllUserDefinedTypes Inherited from TransferBase
CopyAllUsers CopyAllUsers CopyAllUsers Inherited from TransferBase
CopyAllViews CopyAllViews CopyAllViews Inherited from TransferBase
CopyAllXmlSchemaCollections CopyAllXmlSchemaCollections CopyAllXmlSchemaCollections Inherited from TransferBase
CopyData CopyData CopyData Inherited from TransferBase
CopySchema CopySchema CopySchema Inherited from TransferBase
CreateTargetDatabase CreateTargetDatabase CreateTargetDatabase Inherited from TransferBase
Database Database Database Inherited from TransferBase
DatabaseFileMappings DatabaseFileMappings DatabaseFileMappings Inherited from TransferBase
DestinationDatabase DestinationDatabase DestinationDatabase Inherited from TransferBase
DestinationLogin DestinationLogin DestinationLogin Inherited from TransferBase
DestinationLoginSecure DestinationLoginSecure DestinationLoginSecure

If set to true, Sql Server Authentication is used. If not set, Login and Password are ignored.

(Inherited from TransferBase)
DestinationPassword DestinationPassword DestinationPassword Inherited from TransferBase
DestinationServer DestinationServer DestinationServer Inherited from TransferBase
DestinationTranslateChar DestinationTranslateChar DestinationTranslateChar Inherited from TransferBase
DropDestinationObjectsFirst DropDestinationObjectsFirst DropDestinationObjectsFirst Inherited from TransferBase
ObjectList ObjectList ObjectList Inherited from TransferBase
Options Options Options Inherited from TransferBase
PrefetchObjects PrefetchObjects PrefetchObjects Inherited from TransferBase
PreserveDbo PreserveDbo PreserveDbo Inherited from TransferBase
PreserveLogins PreserveLogins PreserveLogins Inherited from TransferBase
Scripter Scripter Scripter Inherited from TransferBase
SourceTranslateChar SourceTranslateChar SourceTranslateChar Inherited from TransferBase
TargetDatabaseFilePath TargetDatabaseFilePath TargetDatabaseFilePath Inherited from TransferBase
TargetLogFilePath TargetLogFilePath TargetLogFilePath Inherited from TransferBase
TemporaryPackageDirectory TemporaryPackageDirectory TemporaryPackageDirectory
UseDestinationTransaction UseDestinationTransaction UseDestinationTransaction Inherited from TransferBase

Methods

EnumObjects() EnumObjects() EnumObjects() Inherited from TransferBase
EnumScriptTransfer() EnumScriptTransfer() EnumScriptTransfer()

Returns an IEnumerable<string> object with the script for the objects.

(Inherited from TransferBase)
GetTransferProvider() GetTransferProvider() GetTransferProvider()

Returns the component that is used to perform transfer

ProcessDependencyChain(Server, DependencyChainCollection, Boolean, Boolean) ProcessDependencyChain(Server, DependencyChainCollection, Boolean, Boolean) ProcessDependencyChain(Server, DependencyChainCollection, Boolean, Boolean)

Process a dependency chain, into a list of objects. Order is preserved, but duplicates are removed

ScriptTransfer() ScriptTransfer() ScriptTransfer()

Returns a StringCollection object with the script for the objects. This method throws an error if ScriptData is true

(Inherited from TransferBase)
SetTargetServerInfo() SetTargetServerInfo() SetTargetServerInfo()

Sets the target server version based on the Destination server information

(Inherited from TransferBase)
TransferData() TransferData() TransferData()

Performs data transfer

Events

DataTransferEvent DataTransferEvent DataTransferEvent
DiscoveryProgress DiscoveryProgress DiscoveryProgress Inherited from TransferBase
ScriptingError ScriptingError ScriptingError Inherited from TransferBase
ScriptingProgress ScriptingProgress ScriptingProgress Inherited from TransferBase

Explicit Interface Implementations

ITransferMetadataProvider.GetOptions() ITransferMetadataProvider.GetOptions() ITransferMetadataProvider.GetOptions()

returns the options as a collection of named variables

ITransferMetadataProvider.SaveMetadata() ITransferMetadataProvider.SaveMetadata() ITransferMetadataProvider.SaveMetadata()

Save the metadata in the paths provided by the variables in the input list

Applies to