DataTransferBase DataTransferBase DataTransferBase Class

Definition

Represents the data transfer base.

public ref class DataTransferBase abstract : Microsoft::SqlServer::Management::Smo::TransferBase
public abstract class DataTransferBase : Microsoft.SqlServer.Management.Smo.TransferBase
Public MustInherit Class DataTransferBase
Inherits TransferBase
Inheritance
DataTransferBaseDataTransferBaseDataTransferBase
Derived

Constructors

DataTransferBase() DataTransferBase() DataTransferBase()

Initializes a new instance of the DataTransferBase class using default values.

DataTransferBase(Database) DataTransferBase(Database) DataTransferBase(Database)

Initializes a new instance of the DataTransferBase class with specified database.

Properties

CopyAllDatabaseTriggers CopyAllDatabaseTriggers CopyAllDatabaseTriggers

Gets or sets a value that indicates whether all the SQL Server database triggers are copied from the source database to the target database in the transfer operation.

(Inherited from TransferBase)
CopyAllDefaults CopyAllDefaults CopyAllDefaults

Gets or sets a value that indicates whether all the SQL Server defaults are copied from the source database to the target database in the transfer operation.

(Inherited from TransferBase)
CopyAllFullTextCatalogs CopyAllFullTextCatalogs CopyAllFullTextCatalogs

Gets or sets a value that indicates whether all the SQL Server full-text catalogs are copied from the source database to the target database in the transfer operation.

(Inherited from TransferBase)
CopyAllFullTextStopLists CopyAllFullTextStopLists CopyAllFullTextStopLists

Gets or sets a value that indicates whether all the SQL Server full-text stop lists are copied from the source database to the target database in the transfer operation.

(Inherited from TransferBase)
CopyAllLogins CopyAllLogins CopyAllLogins

Gets or sets a value that indicates whether all the SQL Server logins are copied from the source database to the target database in the transfer operation.

(Inherited from TransferBase)
CopyAllObjects CopyAllObjects CopyAllObjects

Gets or sets a value that indicates whether all the SQL Server objects are copied from the source database to the target database in the transfer operation.

(Inherited from TransferBase)
CopyAllPartitionFunctions CopyAllPartitionFunctions CopyAllPartitionFunctions

Gets or sets a value that indicates whether all the SQL Server partition functions are copied from the source database to the target database in the transfer operation.

(Inherited from TransferBase)
CopyAllPartitionSchemes CopyAllPartitionSchemes CopyAllPartitionSchemes

Gets or sets a value that indicates whether all the SQL Server partition schemes are copied from the source database to the target database in the transfer operation.

(Inherited from TransferBase)
CopyAllPlanGuides CopyAllPlanGuides CopyAllPlanGuides

Gets or sets a value that indicates whether all the SQL Server plan guides are copied from the source database to the target database in the transfer operation.

(Inherited from TransferBase)
CopyAllRoles CopyAllRoles CopyAllRoles

Gets or sets a value that indicates whether all the SQL Server roles are copied from the source database to the target database in the transfer operation.

(Inherited from TransferBase)
CopyAllRules CopyAllRules CopyAllRules

Gets or sets a value that indicates whether all the SQL Server rules are copied from the source database to the target database in the transfer operation.

(Inherited from TransferBase)
CopyAllSchemas CopyAllSchemas CopyAllSchemas

Gets or sets a value that indicates whether all the SQL Server schemas are copied from the source database to the target database in the transfer operation.

(Inherited from TransferBase)
CopyAllSearchPropertyLists CopyAllSearchPropertyLists CopyAllSearchPropertyLists

Gets or sets a value that indicates whether all the SQL Server search property lists are copied from the source database to the target database in the transfer operation.

(Inherited from TransferBase)
CopyAllSequences CopyAllSequences CopyAllSequences

Gets or sets a value that indicates whether all the SQL Server sequences are copied from the source database to the target database in the transfer operation.

(Inherited from TransferBase)
CopyAllSqlAssemblies CopyAllSqlAssemblies CopyAllSqlAssemblies

Gets or sets a value that indicates whether all the SQL Server assemblies are copied from the source database to the target database in the transfer operation.

(Inherited from TransferBase)
CopyAllStoredProcedures CopyAllStoredProcedures CopyAllStoredProcedures

Gets or sets a value that indicates whether all the SQL Server stored procedures are copied from the source database to the target database in the transfer operation.

(Inherited from TransferBase)
CopyAllSynonyms CopyAllSynonyms CopyAllSynonyms

Gets or sets a value that indicates whether all the SQL Server synonyms are copied from the source database to the target database in the transfer operation.

(Inherited from TransferBase)
CopyAllTables CopyAllTables CopyAllTables

Gets or sets a value that indicates whether all the SQL Server tables are copied from the source database to the target database in the transfer operation.

(Inherited from TransferBase)
CopyAllUserDefinedAggregates CopyAllUserDefinedAggregates CopyAllUserDefinedAggregates

Gets or sets a value that indicates whether all the SQL Server user-defined aggregates are copied from the source database to the target database in the transfer operation.

(Inherited from TransferBase)
CopyAllUserDefinedDataTypes CopyAllUserDefinedDataTypes CopyAllUserDefinedDataTypes

Gets or sets a value that indicates whether all the SQL Server user-defined data types are copied from the source database to the target database in the transfer operation.

(Inherited from TransferBase)
CopyAllUserDefinedFunctions CopyAllUserDefinedFunctions CopyAllUserDefinedFunctions

Gets or sets a value that indicates whether all the SQL Server user-defined functions are copied from the source database to the target database in the transfer operation.

(Inherited from TransferBase)
CopyAllUserDefinedTableTypes CopyAllUserDefinedTableTypes CopyAllUserDefinedTableTypes

Gets or sets a value that indicates whether all the SQL Server user-defined table types are copied from the source database to the target database in the transfer operation.

(Inherited from TransferBase)
CopyAllUserDefinedTypes CopyAllUserDefinedTypes CopyAllUserDefinedTypes

Gets or sets a value that indicates whether all the SQL Server user-defined types are copied from the source database to the target database in the transfer operation.

(Inherited from TransferBase)
CopyAllUsers CopyAllUsers CopyAllUsers

Gets or sets a value that indicates whether all the SQL Server database users are copied from the source database to the target database in the transfer operation.

(Inherited from TransferBase)
CopyAllViews CopyAllViews CopyAllViews

Gets or sets a value that indicates whether all the SQL Server views are copied from the source database to the target database in the transfer operation.

(Inherited from TransferBase)
CopyAllXmlSchemaCollections CopyAllXmlSchemaCollections CopyAllXmlSchemaCollections

Gets or sets a value that indicates whether all the SQL Server XML schema collections are copied from the source database to the target database in the transfer operation.

(Inherited from TransferBase)
CopyData CopyData CopyData

Gets or sets a value that indicates whether all the data is copied from the source database to the target database in the transfer operation.

(Inherited from TransferBase)
CopySchema CopySchema CopySchema

Gets or sets a value that indicates whether the schema is copied from the source database to the target database in the transfer operation.

(Inherited from TransferBase)
CreateTargetDatabase CreateTargetDatabase CreateTargetDatabase

Gets or sets a value that indicates whether the target database is created in the transfer operation.

(Inherited from TransferBase)
Database Database Database

Gets or sets the database from which schema or data is to be transferred to the target location.

(Inherited from TransferBase)
DatabaseFileMappings DatabaseFileMappings DatabaseFileMappings

Gets or sets the properties that are associated with flat file destination based on a dictionary.

(Inherited from TransferBase)
DestinationDatabase DestinationDatabase DestinationDatabase

Gets or sets the database that is the destination of the transfer operation.

(Inherited from TransferBase)
DestinationLogin DestinationLogin DestinationLogin

Gets or sets the logon for the instance of SQL Server to which the destination database belongs.

(Inherited from TransferBase)
DestinationLoginSecure DestinationLoginSecure DestinationLoginSecure

Gets or sets a value that indicates whether the instance of SQL Server that contains the destination database is enabled for Windows Authentication or not.

(Inherited from TransferBase)
DestinationPassword DestinationPassword DestinationPassword

Gets or sets the logon password for the instance of SQL Server to which the destination database belongs.

(Inherited from TransferBase)
DestinationServer DestinationServer DestinationServer

Gets or sets the instance of SQL Server that owns the database that is the destination of the transfer operation.

(Inherited from TransferBase)
DestinationTranslateChar DestinationTranslateChar DestinationTranslateChar

Gets or sets a value that indicates whether the transfer operation translates the code page for characters on the destination database.

(Inherited from TransferBase)
DropDestinationObjectsFirst DropDestinationObjectsFirst DropDestinationObjectsFirst

Gets or sets a value that indicates whether to drop the objects in the destination database before the transfer operation.

(Inherited from TransferBase)
ObjectList ObjectList ObjectList

Gets or sets the objects copied from the source to destination in the transfer operation.

(Inherited from TransferBase)
Options Options Options

Gets or sets the options for the transfer operation.

(Inherited from TransferBase)
PrefetchObjects PrefetchObjects PrefetchObjects

Gets or sets a value that indicates whether to prefetch the objects before the transfer operation.

(Inherited from TransferBase)
PreserveDbo PreserveDbo PreserveDbo

Gets or sets a value that indicates whether DBO ownerships are retained through the transfer process.

(Inherited from TransferBase)
PreserveLogins PreserveLogins PreserveLogins

Gets or sets a value that indicates whether to preserve logins in the transfer operation.

(Inherited from TransferBase)
Scripter Scripter Scripter

Gets the scripter for the transfer operation.

(Inherited from TransferBase)
SourceTranslateChar SourceTranslateChar SourceTranslateChar

Gets or sets a value that indicates whether the transfer operation translates the code page for characters on the source database.

(Inherited from TransferBase)
TargetDatabaseFilePath TargetDatabaseFilePath TargetDatabaseFilePath

Gets or sets the path to where the database files will be copied.

(Inherited from TransferBase)
TargetLogFilePath TargetLogFilePath TargetLogFilePath

Gets or sets the path to where the log files will be copied.

(Inherited from TransferBase)
UseDestinationTransaction UseDestinationTransaction UseDestinationTransaction

Gets or sets a value that indicates whether to use the destination transaction.

(Inherited from TransferBase)

Events

DiscoveryProgress DiscoveryProgress DiscoveryProgress

Marks the progress of the discovery process.

(Inherited from TransferBase)
ScriptingError ScriptingError ScriptingError

Reports that an error occurred during the scripting process.

(Inherited from TransferBase)
ScriptingProgress ScriptingProgress ScriptingProgress

Marks the progress of the scripting process.

(Inherited from TransferBase)

Methods

EnumObjects() EnumObjects() EnumObjects()

Returns an enumerated list of Uniform Resource Name (URN) values that represent the objects included in the transfer operation.

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

Creates a Transact-SQL command batch script used to transfer database objects or database objects and data to another database instance.

(Inherited from TransferBase)
ScriptTransfer() ScriptTransfer() ScriptTransfer()

Creates a Transact-SQL command batch script that creates database objects that are transferred by the transfer operation.

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

Sets the target server version based on the SQL Server version.

(Inherited from TransferBase)

Applies to