Clase DataTransferBase
Represents the data transfer base.
Jerarquía de herencia
System.Object
Microsoft.SqlServer.Management.Smo.TransferBase
Microsoft.SqlServer.Management.Smo.DataTransferBase
Microsoft.SqlServer.Management.Smo.Transfer
Espacio de nombres: Microsoft.SqlServer.Management.Smo
Ensamblado: Microsoft.SqlServer.SmoExtended (en Microsoft.SqlServer.SmoExtended.dll)
Sintaxis
'Declaración
Public MustInherit Class DataTransferBase _
Inherits TransferBase
'Uso
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
El tipo DataTransferBase expone los siguientes miembros.
Constructores
Nombre | Descripción | |
---|---|---|
DataTransferBase() | Initializes a new instance of the DataTransferBase class using default values. | |
DataTransferBase(Database) | Initializes a new instance of the DataTransferBase class with specified database. |
Arriba
Propiedades
Nombre | Descripción | |
---|---|---|
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. (Se hereda de TransferBase.) | |
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. (Se hereda de TransferBase.) | |
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. (Se hereda de TransferBase.) | |
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. (Se hereda de TransferBase.) | |
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. (Se hereda de TransferBase.) | |
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. (Se hereda de TransferBase.) | |
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. (Se hereda de TransferBase.) | |
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. (Se hereda de TransferBase.) | |
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. (Se hereda de TransferBase.) | |
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. (Se hereda de TransferBase.) | |
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. (Se hereda de TransferBase.) | |
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. (Se hereda de TransferBase.) | |
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. (Se hereda de TransferBase.) | |
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. (Se hereda de TransferBase.) | |
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. (Se hereda de TransferBase.) | |
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. (Se hereda de TransferBase.) | |
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. (Se hereda de TransferBase.) | |
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. (Se hereda de TransferBase.) | |
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. (Se hereda de TransferBase.) | |
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. (Se hereda de TransferBase.) | |
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. (Se hereda de TransferBase.) | |
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. (Se hereda de TransferBase.) | |
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. (Se hereda de TransferBase.) | |
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. (Se hereda de TransferBase.) | |
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. (Se hereda de TransferBase.) | |
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. (Se hereda de TransferBase.) | |
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. (Se hereda de TransferBase.) | |
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. (Se hereda de TransferBase.) | |
CreateTargetDatabase | Gets or sets a value that indicates whether the target database is created in the transfer operation. (Se hereda de TransferBase.) | |
Database | Gets or sets the database from which schema or data is to be transferred to the target location. (Se hereda de TransferBase.) | |
DatabaseFileMappings | Gets or sets the properties that are associated with flat file destination based on a dictionary. (Se hereda de TransferBase.) | |
DestinationDatabase | Gets or sets the database that is the destination of the transfer operation. (Se hereda de TransferBase.) | |
DestinationLogin | Gets or sets the logon for the instance of SQL Server to which the destination database belongs. (Se hereda de TransferBase.) | |
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. (Se hereda de TransferBase.) | |
DestinationPassword | Gets or sets the logon password for the instance of SQL Server to which the destination database belongs. (Se hereda de TransferBase.) | |
DestinationServer | Gets or sets the instance of SQL Server that owns the database that is the destination of the transfer operation. (Se hereda de TransferBase.) | |
DestinationTranslateChar | Gets or sets a value that indicates whether the transfer operation translates the code page for characters on the destination database. (Se hereda de TransferBase.) | |
DropDestinationObjectsFirst | Gets or sets a value that indicates whether to drop the objects in the destination database before the transfer operation. (Se hereda de TransferBase.) | |
ObjectList | Gets or sets the objects copied from the source to destination in the transfer operation. (Se hereda de TransferBase.) | |
Options | Gets or sets the options for the transfer operation. (Se hereda de TransferBase.) | |
PrefetchObjects | Gets or sets a value that indicates whether to prefetch the objects before the transfer operation. (Se hereda de TransferBase.) | |
PreserveDbo | Gets or sets a value that indicates whether DBO ownerships are retained through the transfer process. (Se hereda de TransferBase.) | |
PreserveLogins | Gets or sets a value that indicates whether to preserve logins in the transfer operation. (Se hereda de TransferBase.) | |
Scripter | Gets the scripter for the transfer operation. (Se hereda de TransferBase.) | |
SourceTranslateChar | Gets or sets a value that indicates whether the transfer operation translates the code page for characters on the source database. (Se hereda de TransferBase.) | |
TargetDatabaseFilePath | Gets or sets the path to where the database files will be copied. (Se hereda de TransferBase.) | |
TargetLogFilePath | Gets or sets the path to where the log files will be copied. (Se hereda de TransferBase.) | |
UseDestinationTransaction | Gets or sets a value that indicates whether to use the destination transaction. (Se hereda de TransferBase.) |
Arriba
Métodos
Nombre | Descripción | |
---|---|---|
EnumObjects | Returns an enumerated list of Uniform Resource Name (URN) values that represent the objects included in the transfer operation. (Se hereda de TransferBase.) | |
EnumScriptTransfer | Creates a Transact-SQL command batch script used to transfer database objects or database objects and data to another database instance. (Se hereda de TransferBase.) | |
Equals | (Se hereda de Object.) | |
Finalize | (Se hereda de Object.) | |
GetHashCode | (Se hereda de Object.) | |
GetType | (Se hereda de Object.) | |
MemberwiseClone | (Se hereda de Object.) | |
ScriptTransfer | Creates a Transact-SQL command batch script that creates database objects that are transferred by the transfer operation. (Se hereda de TransferBase.) | |
SetTargetServerInfo | Sets the target server version based on the SQL Server version. (Se hereda de TransferBase.) | |
ToString | (Se hereda de Object.) |
Arriba
Eventos
Nombre | Descripción | |
---|---|---|
DiscoveryProgress | Marks the progress of the discovery process. (Se hereda de TransferBase.) | |
ScriptingError | Reports that an error occurred during the scripting process. (Se hereda de TransferBase.) | |
ScriptingProgress | Marks the progress of the scripting process. (Se hereda de TransferBase.) |
Arriba
Seguridad para subprocesos
Cualquier miembro público static (Shared en Visual Basic) de este tipo es seguro para subprocesos. No se garantiza que los miembros de instancia sean seguros para subprocesos.