TransferBase-Klasse

Represents the base class for transfer.

Vererbungshierarchie

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

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

Syntax

'Declaration
Public MustInherit Class TransferBase
'Usage
Dim instance As TransferBase
public abstract class TransferBase
public ref class TransferBase abstract
[<AbstractClassAttribute>]
type TransferBase =  class end
public abstract class TransferBase

Der TransferBase-Typ macht folgende Elemente verfügbar.

Konstruktoren

  Name Beschreibung
Öffentliche Methode TransferBase() Initializes a new instance of the TransferBase class.
Öffentliche Methode TransferBase(Database) Initializes a new instance of the TransferBase class that uses the specified database as the source of the transfer operation.

Zum Anfang

Eigenschaften

  Name Beschreibung
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft CreateTargetDatabase Gets or sets a value that indicates whether the target database is created in the transfer operation.
Öffentliche Eigenschaft Database Gets or sets the database from which schema or data is to be transferred to the target location.
Öffentliche Eigenschaft DatabaseFileMappings Gets or sets the properties that are associated with flat file destination based on a dictionary.
Öffentliche Eigenschaft DestinationDatabase Gets or sets the database that is the destination of the transfer operation.
Öffentliche Eigenschaft DestinationLogin Gets or sets the logon for the instance of SQL Server to which the destination database belongs.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft DestinationPassword Gets or sets the logon password for the instance of SQL Server to which the destination database belongs.
Öffentliche Eigenschaft DestinationServer Gets or sets the instance of SQL Server that owns the database that is the destination of the transfer operation.
Öffentliche Eigenschaft DestinationTranslateChar Gets or sets a value that indicates whether the transfer operation translates the code page for characters on the destination database.
Öffentliche Eigenschaft DropDestinationObjectsFirst Gets or sets a value that indicates whether to drop the objects in the destination database before the transfer operation.
Öffentliche Eigenschaft ObjectList Gets or sets the objects copied from the source to destination in the transfer operation.
Öffentliche Eigenschaft Options Gets or sets the options for the transfer operation.
Öffentliche Eigenschaft PrefetchObjects Gets or sets a value that indicates whether to prefetch the objects before the transfer operation.
Öffentliche Eigenschaft PreserveDbo Gets or sets a value that indicates whether DBO ownerships are retained through the transfer process.
Öffentliche Eigenschaft PreserveLogins Gets or sets a value that indicates whether to preserve logins in the transfer operation.
Geschützte Eigenschaft Scripter Gets the scripter for the transfer operation.
Öffentliche Eigenschaft SourceTranslateChar Gets or sets a value that indicates whether the transfer operation translates the code page for characters on the source database.
Öffentliche Eigenschaft TargetDatabaseFilePath Gets or sets the path to where the database files will be copied.
Öffentliche Eigenschaft TargetLogFilePath Gets or sets the path to where the log files will be copied.
Öffentliche Eigenschaft UseDestinationTransaction Gets or sets a value that indicates whether to use the destination transaction.

Zum Anfang

Methoden

  Name Beschreibung
Öffentliche Methode EnumObjects Returns an enumerated list of Uniform Resource Name (URN) values that represent the objects included in the transfer operation.
Öffentliche Methode EnumScriptTransfer Creates a Transact-SQL command batch script used to transfer database objects or database objects and data to another database instance.
Öffentliche Methode Equals (Geerbt von Object.)
Geschützte Methode Finalize (Geerbt von Object.)
Öffentliche Methode GetHashCode (Geerbt von Object.)
Öffentliche Methode GetType (Geerbt von Object.)
Geschützte Methode MemberwiseClone (Geerbt von Object.)
Öffentliche Methode ScriptTransfer Creates a Transact-SQL command batch script that creates database objects that are transferred by the transfer operation.
Geschützte Methode SetTargetServerInfo Sets the target server version based on the SQL Server version.
Öffentliche Methode ToString (Geerbt von Object.)

Zum Anfang

Ereignisse

  Name Beschreibung
Öffentliches Ereignis DiscoveryProgress Marks the progress of the discovery process.
Öffentliches Ereignis ScriptingError Reports that an error occurred during the scripting process.
Öffentliches Ereignis ScriptingProgress Marks the progress of the scripting process.

Zum Anfang

Threadsicherheit

Alle öffentlichen static (Shared in Visual Basic)-Elemente dieses Typs sind Threadsicher. Für Instanzelemente wird die Threadsicherheit nicht gewährleistet.

Siehe auch

Verweis

Microsoft.SqlServer.Management.Smo-Namespace