Condividi tramite


TransferBase Class

Definition

Base class for transfer

public abstract class TransferBase
type TransferBase = class
Public MustInherit Class TransferBase
Inheritance
TransferBase
Derived

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