TransferBase 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.

Base class for transfer

public abstract class TransferBase

type TransferBase = class

Public MustInherit Class TransferBase

Inheritance: Object
TransferBase

Derived: Microsoft.SqlServer.Management.Smo.DataTransferBase

Constructors

TransferBase()
TransferBase(Database)

Properties

CopyAllDatabaseScopedCredentials
CopyAllDatabaseTriggers
CopyAllDefaults
CopyAllExternalDataSources
CopyAllExternalFileFormats
CopyAllExternalLibraries
CopyAllFeatureRestrictions
CopyAllFullTextCatalogs
CopyAllFullTextStopLists
CopyAllLogins
CopyAllObjects
CopyAllPartitionFunctions
CopyAllPartitionSchemes
CopyAllPlanGuides
CopyAllRoles
CopyAllRules
CopyAllSchemas
CopyAllSearchPropertyLists
CopyAllSequences
CopyAllSqlAssemblies
CopyAllStoredProcedures
CopyAllSynonyms
CopyAllTables
CopyAllUserDefinedAggregates
CopyAllUserDefinedDataTypes
CopyAllUserDefinedFunctions
CopyAllUserDefinedTableTypes
CopyAllUserDefinedTypes
CopyAllUsers
CopyAllViews
CopyAllXmlSchemaCollections
CopyData
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.
CopySchema
CreateTargetDatabase
Database
DatabaseFileMappings
DestinationDatabase	The name of the destination database
DestinationLogin	The login name to use to connect to the destination server
DestinationLoginSecure	If set to true, Sql Server Authentication is used. If not set, Login and Password are ignored.
DestinationPassword	The password to use to connect to the destination server
DestinationServer	The name of the destination server
DestinationTranslateChar
DropDestinationObjectsFirst
IncompatibleObjects
ObjectList
Options	Specifies the options that control script generation for the Transfer
PrefetchObjects
PreserveDbo
PreserveLogins
Scripter
SourceTranslateChar
TargetDatabaseFilePath	The folder on the destination used to store database data files
TargetLogFilePath	The folder on the destination used to store database log fles
UseDestinationTransaction

Methods

EnumObjects()	Gets URNs to be transferred
EnumObjects(Boolean)	Gets URNs to be transferred
EnumScriptTransfer()	Returns an IEnumerable<string> object with the script for the objects.
ScriptTransfer()	Returns a StringCollection object with the script for the objects. This method throws an error if ScriptData is true
SetTargetServerInfo()	Sets the target server version based on the Destination server information

Events

DiscoveryProgress
ScriptingError
ScriptingProgress

Applies to

Partager via