Transfer Class
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Instance class encapsulating Transfer object
public class Transfer : Microsoft.SqlServer.Management.Smo.DataTransferBase, Microsoft.SqlServer.Management.Common.ITransferMetadataProvidertype Transfer = class
inherit DataTransferBase
interface ITransferMetadataProviderPublic Class Transfer
Inherits DataTransferBase
Implements ITransferMetadataProvider- Inheritance
- Implements
Constructors
| Transfer() | |
| Transfer(Database) |
Properties
| 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 |
Number of seconds for the operation to complete before SqlBulkCopy times out. |
| CopyAllDatabaseScopedCredentials | (Inherited from TransferBase) |
| CopyAllDatabaseTriggers | (Inherited from TransferBase) |
| CopyAllDefaults | (Inherited from TransferBase) |
| CopyAllExternalDataSources | (Inherited from TransferBase) |
| CopyAllExternalFileFormats | (Inherited from TransferBase) |
| CopyAllExternalLibraries | (Inherited from TransferBase) |
| CopyAllFeatureRestrictions | (Inherited from TransferBase) |
| CopyAllFullTextCatalogs | (Inherited from TransferBase) |
| CopyAllFullTextStopLists | (Inherited from TransferBase) |
| CopyAllLogins | (Inherited from TransferBase) |
| CopyAllObjects | (Inherited from TransferBase) |
| CopyAllPartitionFunctions | (Inherited from TransferBase) |
| CopyAllPartitionSchemes | (Inherited from TransferBase) |
| CopyAllPlanGuides | (Inherited from TransferBase) |
| CopyAllRoles | (Inherited from TransferBase) |
| CopyAllRules | (Inherited from TransferBase) |
| CopyAllSchemas | (Inherited from TransferBase) |
| CopyAllSearchPropertyLists | (Inherited from TransferBase) |
| CopyAllSequences | (Inherited from TransferBase) |
| CopyAllSqlAssemblies | (Inherited from TransferBase) |
| CopyAllStoredProcedures | (Inherited from TransferBase) |
| CopyAllSynonyms | (Inherited from TransferBase) |
| CopyAllTables | (Inherited from TransferBase) |
| CopyAllUserDefinedAggregates | (Inherited from TransferBase) |
| CopyAllUserDefinedDataTypes | (Inherited from TransferBase) |
| CopyAllUserDefinedFunctions | (Inherited from TransferBase) |
| CopyAllUserDefinedTableTypes | (Inherited from TransferBase) |
| CopyAllUserDefinedTypes | (Inherited from TransferBase) |
| CopyAllUsers | (Inherited from TransferBase) |
| CopyAllViews | (Inherited from TransferBase) |
| CopyAllXmlSchemaCollections | (Inherited from TransferBase) |
| CopyData | (Inherited from TransferBase) |
| CopyExternalTables |
Sets or gets a value indicating whether external tables will be scripted. By default we don't script them in Transfer because we are unable to also script the correct credential secret to access the external data source. The UI will set this to true for Generate Scripts wizard. (Inherited from TransferBase) |
| CopySchema | (Inherited from TransferBase) |
| CreateTargetDatabase | (Inherited from TransferBase) |
| Database | (Inherited from TransferBase) |
| DatabaseFileMappings | (Inherited from TransferBase) |
| DestinationDatabase |
The name of the destination database (Inherited from TransferBase) |
| DestinationLogin |
The login name to use to connect to the destination server (Inherited from TransferBase) |
| DestinationLoginSecure |
If set to true, Sql Server Authentication is used. If not set, Login and Password are ignored. (Inherited from TransferBase) |
| DestinationPassword |
The password to use to connect to the destination server (Inherited from TransferBase) |
| DestinationServer |
The name of the destination server (Inherited from TransferBase) |
| DestinationTranslateChar | (Inherited from TransferBase) |
| DropDestinationObjectsFirst | (Inherited from TransferBase) |
| IncompatibleObjects | (Inherited from TransferBase) |
| LogTransferDumps | (Inherited from DataTransferBase) |
| ObjectList | (Inherited from TransferBase) |
| Options |
Specifies the options that control script generation for the Transfer (Inherited from TransferBase) |
| PrefetchObjects | (Inherited from TransferBase) |
| PreserveDbo | (Inherited from TransferBase) |
| PreserveLogins | (Inherited from TransferBase) |
| Scripter | (Inherited from TransferBase) |
| SourceTranslateChar | (Inherited from TransferBase) |
| TargetDatabaseFilePath |
The folder on the destination used to store database data files (Inherited from TransferBase) |
| TargetLogFilePath |
The folder on the destination used to store database log fles (Inherited from TransferBase) |
| TemporaryPackageDirectory | |
| UseDestinationTransaction | (Inherited from TransferBase) |
Methods
| EnumObjects() |
Gets URNs to be transferred (Inherited from TransferBase) |
| EnumObjects(Boolean) |
Gets URNs to be transferred (Inherited from TransferBase) |
| EnumScriptTransfer() |
Returns an IEnumerable<string> object with the script for the objects. (Inherited from TransferBase) |
| GetTransferProvider() |
Returns the component that is used to perform transfer |
| ProcessDependencyChain(Server, DependencyChainCollection, Boolean, Boolean) |
Process a dependency chain, into a list of objects. Order is preserved, but duplicates are removed |
| ScriptTransfer() |
Returns a StringCollection object with the script for the objects. This method throws an error if ScriptData is true (Inherited from TransferBase) |
| SetTargetServerInfo() |
Sets the target server version based on the Destination server information (Inherited from TransferBase) |
| TransferData() |
Performs data transfer |
Events
| DataTransferEvent | |
| DiscoveryProgress | (Inherited from TransferBase) |
| ScriptingError | (Inherited from TransferBase) |
| ScriptingProgress | (Inherited from TransferBase) |
Explicit Interface Implementations
| ITransferMetadataProvider.GetOptions() |
returns the options as a collection of named variables |
| ITransferMetadataProvider.SaveMetadata() |
Save the metadata in the paths provided by the variables in the input list |