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) 成员都是线程安全的。不保证所有实例成员都是线程安全的。

请参阅

参考

Microsoft.SqlServer.Management.Smo 命名空间