共用方式為


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:

  • 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) 成員都可用於多執行緒作業。並不是所有的執行個體成員都保證可以用於所有的執行緒。 

範例

傳送資料

繼承階層

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

執行緒安全性

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