Compartilhar via

  • Artigo

Classe Transfer

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

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.SmoExtended (em Microsoft.SqlServer.SmoExtended.dll)

Sintaxe

'Declaração
Public Class Transfer _
    Implements ITransferMetadataProvider
'Uso
Dim instance As Transfer

public class Transfer : ITransferMetadataProvider

public ref class Transfer : ITransferMetadataProvider

type Transfer =  
    class
        interface ITransferMetadataProvider
    end

public class Transfer implements ITransferMetadataProvider

Comentários

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

Qualquer membro público estático (Compartilhado no Microsoft Visual Basic) desse tipo é seguro para operações multi-threaded. Não há garantia de que qualquer membro de instância seja seguro para threads. 

Hierarquia de herança

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

Segurança de thread

Quaisquer membros static (Shared no Visual Basic) públicos deste tipo são thread-safe. Não há garantia de que qualquer membro de instância seja thread-safe.