DataTransferBase 类
Represents the data transfer base.
继承层次结构
System.Object
Microsoft.SqlServer.Management.Smo.TransferBase
Microsoft.SqlServer.Management.Smo.DataTransferBase
Microsoft.SqlServer.Management.Smo.Transfer
命名空间: Microsoft.SqlServer.Management.Smo
程序集: Microsoft.SqlServer.SmoExtended(在 Microsoft.SqlServer.SmoExtended.dll 中)
语法
声明
Public MustInherit Class DataTransferBase _
Inherits TransferBase
用法
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
DataTransferBase 类型公开以下成员。
构造函数
名称 | 说明 | |
---|---|---|
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. |
页首
属性
名称 | 说明 | |
---|---|---|
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. (从 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. (从 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. (从 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. (从 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. (从 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. (从 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. (从 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. (从 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. (从 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. (从 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. (从 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. (从 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. (从 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. (从 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. (从 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. (从 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. (从 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. (从 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. (从 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. (从 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. (从 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. (从 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. (从 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. (从 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. (从 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. (从 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. (从 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. (从 TransferBase 继承。) | |
CreateTargetDatabase | Gets or sets a value that indicates whether the target database is created in the transfer operation. (从 TransferBase 继承。) | |
Database | Gets or sets the database from which schema or data is to be transferred to the target location. (从 TransferBase 继承。) | |
DatabaseFileMappings | Gets or sets the properties that are associated with flat file destination based on a dictionary. (从 TransferBase 继承。) | |
DestinationDatabase | Gets or sets the database that is the destination of the transfer operation. (从 TransferBase 继承。) | |
DestinationLogin | Gets or sets the logon for the instance of SQL Server to which the destination database belongs. (从 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. (从 TransferBase 继承。) | |
DestinationPassword | Gets or sets the logon password for the instance of SQL Server to which the destination database belongs. (从 TransferBase 继承。) | |
DestinationServer | Gets or sets the instance of SQL Server that owns the database that is the destination of the transfer operation. (从 TransferBase 继承。) | |
DestinationTranslateChar | Gets or sets a value that indicates whether the transfer operation translates the code page for characters on the destination database. (从 TransferBase 继承。) | |
DropDestinationObjectsFirst | Gets or sets a value that indicates whether to drop the objects in the destination database before the transfer operation. (从 TransferBase 继承。) | |
ObjectList | Gets or sets the objects copied from the source to destination in the transfer operation. (从 TransferBase 继承。) | |
Options | Gets or sets the options for the transfer operation. (从 TransferBase 继承。) | |
PrefetchObjects | Gets or sets a value that indicates whether to prefetch the objects before the transfer operation. (从 TransferBase 继承。) | |
PreserveDbo | Gets or sets a value that indicates whether DBO ownerships are retained through the transfer process. (从 TransferBase 继承。) | |
PreserveLogins | Gets or sets a value that indicates whether to preserve logins in the transfer operation. (从 TransferBase 继承。) | |
Scripter | Gets the scripter for the transfer operation. (从 TransferBase 继承。) | |
SourceTranslateChar | Gets or sets a value that indicates whether the transfer operation translates the code page for characters on the source database. (从 TransferBase 继承。) | |
TargetDatabaseFilePath | Gets or sets the path to where the database files will be copied. (从 TransferBase 继承。) | |
TargetLogFilePath | Gets or sets the path to where the log files will be copied. (从 TransferBase 继承。) | |
UseDestinationTransaction | Gets or sets a value that indicates whether to use the destination transaction. (从 TransferBase 继承。) |
页首
方法
名称 | 说明 | |
---|---|---|
EnumObjects | Returns an enumerated list of Uniform Resource Name (URN) values that represent the objects included in the transfer operation. (从 TransferBase 继承。) | |
EnumScriptTransfer | Creates a Transact-SQL command batch script used to transfer database objects or database objects and data to another database instance. (从 TransferBase 继承。) | |
Equals | (从 Object 继承。) | |
Finalize | (从 Object 继承。) | |
GetHashCode | (从 Object 继承。) | |
GetType | (从 Object 继承。) | |
MemberwiseClone | (从 Object 继承。) | |
ScriptTransfer | Creates a Transact-SQL command batch script that creates database objects that are transferred by the transfer operation. (从 TransferBase 继承。) | |
SetTargetServerInfo | Sets the target server version based on the SQL Server version. (从 TransferBase 继承。) | |
ToString | (从 Object 继承。) |
页首
事件
名称 | 说明 | |
---|---|---|
DiscoveryProgress | Marks the progress of the discovery process. (从 TransferBase 继承。) | |
ScriptingError | Reports that an error occurred during the scripting process. (从 TransferBase 继承。) | |
ScriptingProgress | Marks the progress of the scripting process. (从 TransferBase 继承。) |
页首
线程安全
此类型的任何公共 static(在 Visual Basic 中为 Shared) 成员都是线程安全的。不保证所有实例成员都是线程安全的。