Clase Transfer

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

Jerarquía de herencia

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

Espacio de nombres:  Microsoft.SqlServer.Management.Smo
Ensamblado:  Microsoft.SqlServer.SmoExtended (en Microsoft.SqlServer.SmoExtended.dll)

Sintaxis

'Declaración
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

El tipo Transfer expone los siguientes miembros.

Constructores

	Nombre	Descripción
	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.

Arriba

Propiedades

	Nombre	Descripción
	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 a Boolean value that specifies whether DBO ownerships 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.

Arriba

Métodos

	Nombre	Descripción
	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	(Se hereda de Object.)
	Finalize	(Se hereda de Object.)
	GetHashCode	(Se hereda de Object.)
	GetTransferProvider	Returns the data transfer provider interface.
	GetType	(Se hereda de Object.)
	MemberwiseClone	(Se hereda de Object.)
	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	(Se hereda de Object.)
	TransferData	Transfers data as specified by the Transfer object.

Arriba

Eventos

	Nombre	Descripción
	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.

Arriba

Implementaciones de interfaces explícitas

	Nombre	Descripción
	ITransferMetadataProvider. . :: . .GetOptions	The ITransferMetadataProvider class represents an interface that implements the transfer metadata process on the referenced connection.
	ITransferMetadataProvider. . :: . .SaveMetadata	Saves metadata when transferring databases across instances.

Arriba

Comentarios

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

Todos los miembros estáticos (compartidos en Microsoft Visual Basic) públicos de este tipo son seguros para operaciones multiproceso. No se garantiza que los miembros de instancia sean seguros para subprocesos. 

Ejemplos

Transferir datos

Seguridad para subprocesos

Cualquier miembro público static (Shared en Visual Basic) de este tipo es seguro para subprocesos. No se garantiza que los miembros de instancia sean seguros para subprocesos.

Vea también

Referencia

Espacio de nombres Microsoft.SqlServer.Management.Smo