DataTransferBase Class

Reference

Definition

Namespace:: Microsoft.SqlServer.Management.Smo

Assembly:: Microsoft.SqlServer.SmoExtended.dll

Package:: Microsoft.SqlServer.SqlManagementObjects v150.18208.0

Package:: Microsoft.SqlServer.SqlManagementObjects v160.2004021.0

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.

public abstract class DataTransferBase : Microsoft.SqlServer.Management.Smo.TransferBase

type DataTransferBase = class
    inherit TransferBase

Public MustInherit Class DataTransferBase
Inherits TransferBase

Inheritance: Object

TransferBase
DataTransferBase

Derived: Microsoft.SqlServer.Management.Smo.Transfer

Constructors

DataTransferBase()
DataTransferBase(Database)

Properties

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
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)
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)
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)

Events

DiscoveryProgress	(Inherited from TransferBase)
ScriptingError	(Inherited from TransferBase)
ScriptingProgress	(Inherited from TransferBase)

Applies to

Partilhar via