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.

Hierarquia de herança

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

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

O tipo Transfer expõe os membros a seguir.

Construtores

  Nome Descrição
Método público Transfer() () () () Initializes a new instance of the Transfer class.
Método público Transfer(Database) Initializes a new instance of the Transfer class that uses the specified database as the source of the transfer operation.

Início

Propriedades

  Nome Descrição
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública CreateTargetDatabase Gets or sets the Boolean property value that specifies whether the target database is created in the transfer operation.
Propriedade pública Database Gets or sets the database from which schema or data is to be transferred to the target location.
Propriedade pública DatabaseFileMappings Gets or sets properties that are associated with flat file destination based on a DatabaseFileMappingsDictionary object.
Propriedade pública DestinationDatabase Gets or sets the database that is the destination of the transfer operation.
Propriedade pública DestinationLogin Gets or sets the logon for the instance of SQL Server to which the destination database belongs.
Propriedade pública 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.
Propriedade pública DestinationPassword Gets or sets the logon password for the instance of SQL Server to which the destination database belongs.
Propriedade pública DestinationServer Gets or sets the instance of SQL Server that owns the database that is the destination of the transfer operation.
Propriedade pública DestinationTranslateChar Gets or sets the Boolean property value that specifies whether the transfer operation translates the code page for characters on the destination database.
Propriedade pública DropDestinationObjectsFirst Gets or sets the Boolean property value that specifies whether to drop the objects in the destination database before the transfer operation.
Propriedade pública ObjectList Gets or sets the objects copied from the source to destination in the transfer operation.
Propriedade pública Options Gets or sets the options for the transfer operation.
Propriedade pública PrefetchObjects Gets or sets the Boolean property that specifies whether to prefetch the objects before the transfer operation.
Propriedade pública PreserveDbo Gets or sets a Boolean value that specifies whether DBO ownerships are retained through the transfer process.
Propriedade pública PreserveLogins Gets or sets the Boolean property that specifies whether to preserve logins in the transfer operation.
Propriedade pública SourceTranslateChar Gets or sets the Boolean property value that specifies whether the transfer operation translates the code page for characters on the source database.
Propriedade pública TargetDatabaseFilePath Gets or sets the path to where the database files will be copied.
Propriedade pública TargetLogFilePath Gets or sets the path to where the database files will be copied.
Propriedade pública TemporaryPackageDirectory Gets or sets the file location for storage of temporary packages created during the transfer operation.
Propriedade pública UseDestinationTransaction Gets or sets the Boolean property value that specifies whether to use the destination transaction.

Início

Métodos

  Nome Descrição
Método público EnumObjects Returns an enumerated list of Uniform Resource Name (URN) values that represent the objects included in the transfer operation.
Método público EnumScriptTransfer Creates a Transact-SQL command batch script used to transfer database objects or database objects and data to another database instance.
Método público Equals (Herdado de Object.)
Método protegido Finalize (Herdado de Object.)
Método público GetHashCode (Herdado de Object.)
Método público GetTransferProvider Returns the data transfer provider interface.
Método público GetType (Herdado de Object.)
Método protegido MemberwiseClone (Herdado de Object.)
Método protegidoMembro estático ProcessDependencyChain Returns a URN array with options.
Método público ScriptTransfer Creates a Transact-SQL command batch script that creates database objects that are transferred by the transfer operation.
Método público ToString (Herdado de Object.)
Método público TransferData Transfers data as specified by the Transfer object.

Início

Eventos

  Nome Descrição
Evento público DataTransferEvent Reports that data has been transferred.
Evento público DiscoveryProgress Marks the progress of the discovery process.
Evento público ScriptingError Reports that an error occurred during the scripting process.
Evento público ScriptingProgress Marks the progress of the scripting process.

Início

Implementações de interfaces explícitas

  Nome Descrição
Implementações de interfaces explícitasMétodo privado ITransferMetadataProvider. . :: . .GetOptions The ITransferMetadataProvider class represents an interface that implements the transfer metadata process on the referenced connection.
Implementações de interfaces explícitasMétodo privado ITransferMetadataProvider. . :: . .SaveMetadata Saves metadata when transferring databases across instances.

Início

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. 

Segurança de thread

Qualquer membro público static (Shared no Visual Basic) desse tipo é seguro para threads. Não há garantia de que qualquer membro de instância seja seguro para threads.

Consulte também

Referência

Namespace Microsoft.SqlServer.Management.Smo