Transfer 类

The Transfer object is a tool object that provides programmatic control over copying of schemas and data to other instances of SQL Server.

继承层次结构

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 Class Transfer _
    Inherits DataTransferBase _
    Implements ITransferMetadataProvider
用法
Dim instance As Transfer

public class Transfer : DataTransferBase, ITransferMetadataProvider

public ref class Transfer : public DataTransferBase, 
    ITransferMetadataProvider

type Transfer =  
    class 
        inherit DataTransferBase 
        interface ITransferMetadataProvider 
    end

public class Transfer extends DataTransferBase implements ITransferMetadataProvider

Transfer 类型公开以下成员。

构造函数

	名称	说明
	Transfer()	Initializes a new instance of the Transfer class.
	Transfer(Database)	Initializes a new instance of the Transfer class that uses the specified database as the source of the transfer operation.

页首

属性

	名称	说明
	BatchSize	Gets or sets the batch size property.
	BulkCopyTimeout	Gets or sets the operation to complete before it times out.
	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 继承。）
	TemporaryPackageDirectory	For internal use only. The value of this property is ignored if set by a caller.
	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 继承。）
	GetTransferProvider	For internal use only. Throws a System.NotSupportedException if invoked by a caller.
	GetType	（从 Object 继承。）
	MemberwiseClone	（从 Object 继承。）
	ProcessDependencyChain	Returns a URN array with options.
	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 继承。）
	TransferData	Transfers data as specified by the Transfer object.

页首

事件

	名称	说明
	DataTransferEvent	Reports that data has been transferred.
	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 继承。）

页首

显式接口实现

	名称	说明
	ITransferMetadataProvider.GetOptions	The ITransferMetadataProvider class represents an interface that implements the transfer metadata process on the referenced connection.
	ITransferMetadataProvider.SaveMetadata	Saves metadata when transferring databases across instances.

页首

注释

The following object types cannot be transferred:

• All broker objects

• All mail objects

• Endpoint

• ServerDdlTrigger

• ExtendedStoredProcedure

• FullTextCatalog

• UserDefinedMessage

• ApplicationRole

To get and set Transfer object properties, users can be a member of the public fixed server role.

To transfer data, users can be a member of the public fixed server role.

Thread Safety

此类型的任何公共静态（Microsoft Visual Basic 中的 Shared）成员在多线程操作中是安全的。但不保证所有实例成员都是线程安全的。  

示例

传输数据

线程安全

此类型的任何公共 static（在 Visual Basic 中为 Shared） 成员都是线程安全的。不保证所有实例成员都是线程安全的。

请参阅

参考

Microsoft.SqlServer.Management.Smo 命名空间