Transfer 類別

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

命名空間： 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

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:

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.

這種類型的任何公用靜態 (在 Microsoft Visual Basic 中則為 Shared) 成員都可用於多執行緒作業。並不是所有的執行個體成員都保證可以用於所有的執行緒。

System. . :: . .Object
Microsoft.SqlServer.Management.Smo..::..Transfer

這個類型的任何公用static (在 Visual Basic 中為 Shared) 成員都是安全執行緒。不保證任何執行個體成員都可以是安全執行緒。