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..::..Transfer
命名空间： Microsoft.SqlServer.Management.Smo
程序集： Microsoft.SqlServer.SmoExtended（在 Microsoft.SqlServer.SmoExtended.dll 中）
语法
声明
Public Class Transfer _
Implements ITransferMetadataProvider
用法
Dim instance As Transfer
public class Transfer : ITransferMetadataProvider
public ref class Transfer : ITransferMetadataProvider
type Transfer =
class
interface ITransferMetadataProvider
end
public class Transfer implements ITransferMetadataProvider
Transfer 类型公开以下成员。
构造函数
| 名称 | 说明 | |
|---|---|---|
.gif "公共方法") |
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. |
页首
属性
| 名称 | 说明 | |
|---|---|---|
.gif "公共属性") |
CopyAllDatabaseTriggers | Gets or sets the Boolean property value that specifies whether all the SQL Server database triggers are copied from the source database to the target database in the transfer operation. |
|
CopyAllDefaults | Gets or sets the Boolean property value that specifies whether all the SQL Server defaults are copied from the source database to the target database in the transfer operation. |
|
CopyAllFullTextCatalogs | Gets or sets the Boolean property value that specifies whether all the SQL Server Full-Text catalogs are copied from the source database to the target database in the transfer operation. |
|
CopyAllFullTextStopLists | Gets or sets the Boolean property value that specifies whether all the SQL Server full-text stop lists are copied from the source database to the target database in the transfer operation. |
|
CopyAllLogins | Gets or sets the Boolean property value that specifies whether all the SQL Server logins are copied from the source database to the target database in the transfer operation. |
|
CopyAllObjects | Gets or sets the Boolean property value that specifies whether all the SQL Server objects are copied from the source database to the target database in the transfer operation. |
|
CopyAllPartitionFunctions | Gets or sets the Boolean property value that specifies whether all the SQL Server partition functions are copied from the source database to the target database in the transfer operation. |
|
CopyAllPartitionSchemes | Gets or sets the Boolean property value that specifies whether all the SQL Server partition schemes are copied from the source database to the target database in the transfer operation. |
|
CopyAllPlanGuides | Gets or sets the Boolean property value that specifies whether all the SQL Server plan guides are copied from the source database to the target database in the transfer operation. |
|
CopyAllRoles | Gets or sets the Boolean property value that specifies whether all the SQL Server roles are copied from the source database to the target database in the transfer operation. |
|
CopyAllRules | Gets or sets the Boolean property value that specifies whether all the SQL Server rules are copied from the source database to the target database in the transfer operation. |
|
CopyAllSchemas | Gets or sets the Boolean property value that specifies whether all the SQL Server schemas are copied from the source database to the target database in the transfer operation. |
|
CopyAllSqlAssemblies | Gets or sets the Boolean property value that specifies whether all the SQL Server assemblies are copied from the source database to the target database in the transfer operation. |
|
CopyAllStoredProcedures | Gets or sets the Boolean property value that specifies whether all the SQL Server stored procedures are copied from the source database to the target database in the transfer operation. |
|
CopyAllSynonyms | Gets or sets the Boolean property value that specifies whether all the SQL Server synonyms are copied from the source database to the target database in the transfer operation. |
|
CopyAllTables | Gets or sets the Boolean property value that specifies whether all the SQL Server tables are copied from the source database to the target database in the transfer operation. |
|
CopyAllUserDefinedAggregates | Gets or sets the Boolean property value that specifies whether all the SQL Server user-defined aggregates are copied from the source database to the target database in the transfer operation. |
|
CopyAllUserDefinedDataTypes | Gets or sets the Boolean property value that specifies whether all the SQL Server user-defined data types are copied from the source database to the target database in the transfer operation. |
|
CopyAllUserDefinedFunctions | Gets or sets the Boolean property value that specifies whether all the SQL Server user-defined functions are copied from the source database to the target database in the transfer operation. |
|
CopyAllUserDefinedTableTypes | Gets or sets the Boolean property value that specifies whether all the SQL Server user-defined table types are copied from the source database to the target database in the transfer operation. |
|
CopyAllUserDefinedTypes | Gets or sets the Boolean property value that specifies whether all the SQL Server user-defined types are copied from the source database to the target database in the transfer operation. |
|
CopyAllUsers | Gets or sets the Boolean property value that specifies whether all the SQL Server database users are copied from the source database to the target database in the transfer operation. |
|
CopyAllViews | Gets or sets the Boolean property value that specifies whether all the SQL Server views are copied from the source database to the target database in the transfer operation. |
|
CopyAllXmlSchemaCollections | Gets or sets the Boolean property value that specifies whether all the SQL Server XML schema collections are copied from the source database to the target database in the transfer operation. |
|
CopyData | Gets or sets the Boolean property value that specifies whether all the data is copied from the source database to the target database in the transfer operation. |
|
CopySchema | Gets or sets the Boolean property value that specifies whether the schema is copied from the source database to the target database in the transfer operation. |
|
CreateTargetDatabase | Gets or sets the Boolean property value that specifies whether the target database is created in the transfer operation. |
|
Database | Gets or sets the database from which schema or data is to be transferred to the target location. |
|
DatabaseFileMappings | Gets or sets properties that are associated with flat file destination based on a DatabaseFileMappingsDictionary object. |
|
DestinationDatabase | Gets or sets the database that is the destination of the transfer operation. |
|
DestinationLogin | Gets or sets the logon for the instance of SQL Server to which the destination database belongs. |
|
DestinationLoginSecure | Gets or sets the Boolean property that specifies whether the instance of SQL Server that contains the destination database is enabled for Windows Authentication or not. |
|
DestinationPassword | Gets or sets the logon password for the instance of SQL Server to which the destination database belongs. |
|
DestinationServer | Gets or sets the instance of SQL Server that owns the database that is the destination of the transfer operation. |
|
DestinationTranslateChar | Gets or sets the Boolean property value that specifies whether the transfer operation translates the code page for characters on the destination database. |
|
DropDestinationObjectsFirst | Gets or sets the Boolean property value that specifies whether to drop the objects in the destination database before the transfer operation. |
|
ObjectList | Gets or sets the objects copied from the source to destination in the transfer operation. |
|
Options | Gets or sets the options for the transfer operation. |
|
PrefetchObjects | Gets or sets the Boolean property that specifies whether to prefetch the objects before the transfer operation. |
|
PreserveDbo | Gets or sets the Boolean property value that specifies are retained through the transfer process. |
|
PreserveLogins | Gets or sets the Boolean property that specifies whether to preserve logins in the transfer operation. |
|
SourceTranslateChar | Gets or sets the Boolean property value that specifies whether the transfer operation translates the code page for characters on the source database. |
|
TargetDatabaseFilePath | Gets or sets the path to where the database files will be copied. |
|
TargetLogFilePath | Gets or sets the path to where the database files will be copied. |
|
TemporaryPackageDirectory | Gets or sets the file location for storage of temporary packages created during the transfer operation. |
|
UseDestinationTransaction | Gets or sets the Boolean property value that specifies whether to use the destination transaction. |
页首
方法
| 名称 | 说明 | |
|---|---|---|
|
EnumObjects | Returns an enumerated list of Uniform Resource Name (URN) values that represent the objects included in the transfer operation. |
|
EnumScriptTransfer | Creates a Transact-SQL command batch script used to transfer database objects or database objects and data to another database instance. |
|
Equals | （从 Object 继承。） |
.gif "受保护方法") |
Finalize | （从 Object 继承。） |
|
GetHashCode | （从 Object 继承。） |
|
GetTransferProvider | Returns the data transfer provider interface. |
|
GetType | （从 Object 继承。） |
|
MemberwiseClone | （从 Object 继承。） |
.gif "静态成员") |
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. |
|
ToString | （从 Object 继承。） |
|
TransferData | Transfers data as specified by the Transfer object. |
页首
事件
| 名称 | 说明 | |
|---|---|---|
.gif "公共事件") |
DataTransferEvent | Reports that data has been transferred. |
|
DiscoveryProgress | Marks the progress of the discovery process. |
|
ScriptingError | Reports that an error occurred during the scripting process. |
|
ScriptingProgress | Marks the progress of the scripting process. |
页首
显式接口实现
| 名称 | 说明 | |
|---|---|---|
.gif "显式接口实现") .gif "私有方法") |
ITransferMetadataProvider. . :: . .GetOptions | |
|
ITransferMetadataProvider. . :: . .SaveMetadata |
页首
注释
There are some limitations when transferring a database to a server instance that is running SQL Server 2000:
If the database has a schema for which there is no corresponding user on the target SQL Server 2000 server instance, it cannot be transferred. In this case, you have to create a user who has a name that is the same as the name of the schema.
Any object that uses the following data types cannot be transferred:
SqlDataType.Xml
SqlDataType.VarCharMax
SqlDataType.NVarCharMax
SqlDataType.VarBinaryMax
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） 成员都是线程安全的。不保证所有实例成员都是线程安全的。