Classe DataTransferBase

Represents the data transfer base.

Gerarchia di ereditarietà

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

Spazio dei nomi  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.SmoExtended (in Microsoft.SqlServer.SmoExtended.dll)

Sintassi

'Dichiarazione
Public MustInherit Class DataTransferBase _
    Inherits TransferBase
'Utilizzo
Dim instance As DataTransferBase
public abstract class DataTransferBase : TransferBase
public ref class DataTransferBase abstract : public TransferBase
[<AbstractClassAttribute>]
type DataTransferBase =  
    class 
        inherit TransferBase 
    end
public abstract class DataTransferBase extends TransferBase

Nel tipo DataTransferBase sono esposti i membri seguenti.

Costruttori

  Nome Descrizione
Metodo pubblico DataTransferBase() Initializes a new instance of the DataTransferBase class using default values.
Metodo pubblico DataTransferBase(Database) Initializes a new instance of the DataTransferBase class with specified database.

In alto

Proprietà

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

In alto

Metodi

  Nome Descrizione
Metodo pubblico EnumObjects Returns an enumerated list of Uniform Resource Name (URN) values that represent the objects included in the transfer operation. Ereditato da TransferBase.
Metodo pubblico EnumScriptTransfer Creates a Transact-SQL command batch script used to transfer database objects or database objects and data to another database instance. Ereditato da TransferBase.
Metodo pubblico Equals Ereditato da Object.
Metodo protetto Finalize Ereditato da Object.
Metodo pubblico GetHashCode Ereditato da Object.
Metodo pubblico GetType Ereditato da Object.
Metodo protetto MemberwiseClone Ereditato da Object.
Metodo pubblico ScriptTransfer Creates a Transact-SQL command batch script that creates database objects that are transferred by the transfer operation. Ereditato da TransferBase.
Metodo protetto SetTargetServerInfo Sets the target server version based on the SQL Server version. Ereditato da TransferBase.
Metodo pubblico ToString Ereditato da Object.

In alto

Eventi

  Nome Descrizione
Evento pubblico DiscoveryProgress Marks the progress of the discovery process. Ereditato da TransferBase.
Evento pubblico ScriptingError Reports that an error occurred during the scripting process. Ereditato da TransferBase.
Evento pubblico ScriptingProgress Marks the progress of the scripting process. Ereditato da TransferBase.

In alto

Protezione dei thread

I membri static (Shared in Visual Basic) pubblici di questo tipo sono affidabili. Non è invece garantita la sicurezza dei membri dell'istanza.

Vedere anche

Riferimento

Spazio dei nomi Microsoft.SqlServer.Management.Smo