TransferBase Class

 

Represents the base class for transfer.

Namespace:   Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.SmoExtended (in Microsoft.SqlServer.SmoExtended.dll)

System.Object
  Microsoft.SqlServer.Management.Smo.TransferBase
    Microsoft.SqlServer.Management.Smo.DataTransferBase

Public MustInherit Class TransferBase

NameDescription
System_CAPS_pubmethodTransferBase()

Initializes a new instance of the TransferBase class.

System_CAPS_pubmethodTransferBase(Database)

Initializes a new instance of the TransferBase class that uses the specified database as the source of the transfer operation.

NameDescription
System_CAPS_pubpropertyCopyAllDatabaseTriggers

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.

System_CAPS_pubpropertyCopyAllDefaults

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.

System_CAPS_pubpropertyCopyAllFullTextCatalogs

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.

System_CAPS_pubpropertyCopyAllFullTextStopLists

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.

System_CAPS_pubpropertyCopyAllLogins

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.

System_CAPS_pubpropertyCopyAllObjects

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.

System_CAPS_pubpropertyCopyAllPartitionFunctions

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.

System_CAPS_pubpropertyCopyAllPartitionSchemes

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.

System_CAPS_pubpropertyCopyAllPlanGuides

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.

System_CAPS_pubpropertyCopyAllRoles

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.

System_CAPS_pubpropertyCopyAllRules

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.

System_CAPS_pubpropertyCopyAllSchemas

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.

System_CAPS_pubpropertyCopyAllSearchPropertyLists

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.

System_CAPS_pubpropertyCopyAllSequences

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.

System_CAPS_pubpropertyCopyAllSqlAssemblies

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.

System_CAPS_pubpropertyCopyAllStoredProcedures

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.

System_CAPS_pubpropertyCopyAllSynonyms

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.

System_CAPS_pubpropertyCopyAllTables

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.

System_CAPS_pubpropertyCopyAllUserDefinedAggregates

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.

System_CAPS_pubpropertyCopyAllUserDefinedDataTypes

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.

System_CAPS_pubpropertyCopyAllUserDefinedFunctions

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.

System_CAPS_pubpropertyCopyAllUserDefinedTableTypes

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.

System_CAPS_pubpropertyCopyAllUserDefinedTypes

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.

System_CAPS_pubpropertyCopyAllUsers

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.

System_CAPS_pubpropertyCopyAllViews

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.

System_CAPS_pubpropertyCopyAllXmlSchemaCollections

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.

System_CAPS_pubpropertyCopyData

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.

System_CAPS_pubpropertyCopySchema

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

System_CAPS_pubpropertyCreateTargetDatabase

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

System_CAPS_pubpropertyDatabase

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

System_CAPS_pubpropertyDatabaseFileMappings

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

System_CAPS_pubpropertyDestinationDatabase

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

System_CAPS_pubpropertyDestinationLogin

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

System_CAPS_pubpropertyDestinationLoginSecure

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.

System_CAPS_pubpropertyDestinationPassword

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

System_CAPS_pubpropertyDestinationServer

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

System_CAPS_pubpropertyDestinationTranslateChar

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

System_CAPS_pubpropertyDropDestinationObjectsFirst

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

System_CAPS_pubpropertyObjectList

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

System_CAPS_pubpropertyOptions

Gets or sets the options for the transfer operation.

System_CAPS_pubpropertyPrefetchObjects

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

System_CAPS_pubpropertyPreserveDbo

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

System_CAPS_pubpropertyPreserveLogins

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

System_CAPS_protpropertyScripter

Gets the scripter for the transfer operation.

System_CAPS_pubpropertySourceTranslateChar

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

System_CAPS_pubpropertyTargetDatabaseFilePath

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

System_CAPS_pubpropertyTargetLogFilePath

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

System_CAPS_pubpropertyUseDestinationTransaction

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

NameDescription
System_CAPS_pubmethodEnumObjects()

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

System_CAPS_pubmethodEnumScriptTransfer()

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

System_CAPS_pubmethodEquals(Object)

(Inherited from Object.)

System_CAPS_protmethodFinalize()

(Inherited from Object.)

System_CAPS_pubmethodGetHashCode()

(Inherited from Object.)

System_CAPS_pubmethodGetType()

(Inherited from Object.)

System_CAPS_protmethodMemberwiseClone()

(Inherited from Object.)

System_CAPS_pubmethodScriptTransfer()

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

System_CAPS_protmethodSetTargetServerInfo()

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

System_CAPS_pubmethodToString()

(Inherited from Object.)

NameDescription
System_CAPS_pubeventDiscoveryProgress

Marks the progress of the discovery process.

System_CAPS_pubeventScriptingError

Reports that an error occurred during the scripting process.

System_CAPS_pubeventScriptingProgress

Marks the progress of the scripting process.

Any public static ( Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Return to top
Show: