Partager via

Classe Transfer

  • Article

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

Hiérarchie d'héritage

System.Object
  Microsoft.SqlServer.Management.Smo.TransferBase
    Microsoft.SqlServer.Management.Smo.DataTransferBase
      Microsoft.SqlServer.Management.Smo.Transfer

Espace de noms :  Microsoft.SqlServer.Management.Smo
Assembly :  Microsoft.SqlServer.SmoExtended (en Microsoft.SqlServer.SmoExtended.dll)

Syntaxe

'Déclaration
Public Class Transfer _
    Inherits DataTransferBase _
    Implements ITransferMetadataProvider
'Utilisation
Dim instance As Transfer

public class Transfer : DataTransferBase, ITransferMetadataProvider

public ref class Transfer : public DataTransferBase, 
    ITransferMetadataProvider

type Transfer =  
    class 
        inherit DataTransferBase 
        interface ITransferMetadataProvider 
    end

public class Transfer extends DataTransferBase implements ITransferMetadataProvider

Le type Transfer expose les membres suivants.

Constructeurs

  Nom Description
Méthode publique Transfer() Initializes a new instance of the Transfer class.
Méthode publique Transfer(Database) Initializes a new instance of the Transfer class that uses the specified database as the source of the transfer operation.

Haut de la page

Propriétés

  Nom Description
Propriété publique BatchSize Gets or sets the batch size property.
Propriété publique BulkCopyTimeout Gets or sets the operation to complete before it times out.
Propriété publique CopyAllDatabaseTriggers Gets or sets a value that indicates whether all the SQL Server database triggers are copied from the source database to the target database in the transfer operation. (hérité de TransferBase.)
Propriété publique CopyAllDefaults Gets or sets a value that indicates whether all the SQL Server defaults are copied from the source database to the target database in the transfer operation. (hérité de TransferBase.)
Propriété publique CopyAllFullTextCatalogs Gets or sets a value that indicates whether all the SQL Server full-text catalogs are copied from the source database to the target database in the transfer operation. (hérité de TransferBase.)
Propriété publique CopyAllFullTextStopLists Gets or sets a value that indicates whether all the SQL Server full-text stop lists are copied from the source database to the target database in the transfer operation. (hérité de TransferBase.)
Propriété publique CopyAllLogins Gets or sets a value that indicates whether all the SQL Server logins are copied from the source database to the target database in the transfer operation. (hérité de TransferBase.)
Propriété publique CopyAllObjects Gets or sets a value that indicates whether all the SQL Server objects are copied from the source database to the target database in the transfer operation. (hérité de TransferBase.)
Propriété publique CopyAllPartitionFunctions Gets or sets a value that indicates whether all the SQL Server partition functions are copied from the source database to the target database in the transfer operation. (hérité de TransferBase.)
Propriété publique CopyAllPartitionSchemes Gets or sets a value that indicates whether all the SQL Server partition schemes are copied from the source database to the target database in the transfer operation. (hérité de TransferBase.)
Propriété publique CopyAllPlanGuides Gets or sets a value that indicates whether all the SQL Server plan guides are copied from the source database to the target database in the transfer operation. (hérité de TransferBase.)
Propriété publique CopyAllRoles Gets or sets a value that indicates whether all the SQL Server roles are copied from the source database to the target database in the transfer operation. (hérité de TransferBase.)
Propriété publique CopyAllRules Gets or sets a value that indicates whether all the SQL Server rules are copied from the source database to the target database in the transfer operation. (hérité de TransferBase.)
Propriété publique CopyAllSchemas Gets or sets a value that indicates whether all the SQL Server schemas are copied from the source database to the target database in the transfer operation. (hérité de TransferBase.)
Propriété publique CopyAllSearchPropertyLists Gets or sets a value that indicates whether all the SQL Server search property lists are copied from the source database to the target database in the transfer operation. (hérité de TransferBase.)
Propriété publique CopyAllSequences Gets or sets a value that indicates whether all the SQL Server sequences are copied from the source database to the target database in the transfer operation. (hérité de TransferBase.)
Propriété publique CopyAllSqlAssemblies Gets or sets a value that indicates whether all the SQL Server assemblies are copied from the source database to the target database in the transfer operation. (hérité de TransferBase.)
Propriété publique CopyAllStoredProcedures Gets or sets a value that indicates whether all the SQL Server stored procedures are copied from the source database to the target database in the transfer operation. (hérité de TransferBase.)
Propriété publique CopyAllSynonyms Gets or sets a value that indicates whether all the SQL Server synonyms are copied from the source database to the target database in the transfer operation. (hérité de TransferBase.)
Propriété publique CopyAllTables Gets or sets a value that indicates whether all the SQL Server tables are copied from the source database to the target database in the transfer operation. (hérité de TransferBase.)
Propriété publique CopyAllUserDefinedAggregates Gets or sets a value that indicates whether all the SQL Server user-defined aggregates are copied from the source database to the target database in the transfer operation. (hérité de TransferBase.)
Propriété publique CopyAllUserDefinedDataTypes Gets or sets a value that indicates whether all the SQL Server user-defined data types are copied from the source database to the target database in the transfer operation. (hérité de TransferBase.)
Propriété publique CopyAllUserDefinedFunctions Gets or sets a value that indicates whether all the SQL Server user-defined functions are copied from the source database to the target database in the transfer operation. (hérité de TransferBase.)
Propriété publique CopyAllUserDefinedTableTypes Gets or sets a value that indicates whether all the SQL Server user-defined table types are copied from the source database to the target database in the transfer operation. (hérité de TransferBase.)
Propriété publique CopyAllUserDefinedTypes Gets or sets a value that indicates whether all the SQL Server user-defined types are copied from the source database to the target database in the transfer operation. (hérité de TransferBase.)
Propriété publique CopyAllUsers Gets or sets a value that indicates whether all the SQL Server database users are copied from the source database to the target database in the transfer operation. (hérité de TransferBase.)
Propriété publique CopyAllViews Gets or sets a value that indicates whether all the SQL Server views are copied from the source database to the target database in the transfer operation. (hérité de TransferBase.)
Propriété publique CopyAllXmlSchemaCollections Gets or sets a value that indicates whether all the SQL Server XML schema collections are copied from the source database to the target database in the transfer operation. (hérité de TransferBase.)
Propriété publique CopyData Gets or sets a value that indicates whether all the data is copied from the source database to the target database in the transfer operation. (hérité de TransferBase.)
Propriété publique CopySchema Gets or sets a value that indicates whether the schema is copied from the source database to the target database in the transfer operation. (hérité de TransferBase.)
Propriété publique CreateTargetDatabase Gets or sets a value that indicates whether the target database is created in the transfer operation. (hérité de TransferBase.)
Propriété publique Database Gets or sets the database from which schema or data is to be transferred to the target location. (hérité de TransferBase.)
Propriété publique DatabaseFileMappings Gets or sets the properties that are associated with flat file destination based on a dictionary. (hérité de TransferBase.)
Propriété publique DestinationDatabase Gets or sets the database that is the destination of the transfer operation. (hérité de TransferBase.)
Propriété publique DestinationLogin Gets or sets the logon for the instance of SQL Server to which the destination database belongs. (hérité de TransferBase.)
Propriété publique DestinationLoginSecure Gets or sets a value that indicates whether the instance of SQL Server that contains the destination database is enabled for Windows Authentication or not. (hérité de TransferBase.)
Propriété publique DestinationPassword Gets or sets the logon password for the instance of SQL Server to which the destination database belongs. (hérité de TransferBase.)
Propriété publique DestinationServer Gets or sets the instance of SQL Server that owns the database that is the destination of the transfer operation. (hérité de TransferBase.)
Propriété publique DestinationTranslateChar Gets or sets a value that indicates whether the transfer operation translates the code page for characters on the destination database. (hérité de TransferBase.)
Propriété publique DropDestinationObjectsFirst Gets or sets a value that indicates whether to drop the objects in the destination database before the transfer operation. (hérité de TransferBase.)
Propriété publique ObjectList Gets or sets the objects copied from the source to destination in the transfer operation. (hérité de TransferBase.)
Propriété publique Options Gets or sets the options for the transfer operation. (hérité de TransferBase.)
Propriété publique PrefetchObjects Gets or sets a value that indicates whether to prefetch the objects before the transfer operation. (hérité de TransferBase.)
Propriété publique PreserveDbo Gets or sets a value that indicates whether DBO ownerships are retained through the transfer process. (hérité de TransferBase.)
Propriété publique PreserveLogins Gets or sets a value that indicates whether to preserve logins in the transfer operation. (hérité de TransferBase.)
Propriété protégée Scripter Gets the scripter for the transfer operation. (hérité de TransferBase.)
Propriété publique SourceTranslateChar Gets or sets a value that indicates whether the transfer operation translates the code page for characters on the source database. (hérité de TransferBase.)
Propriété publique TargetDatabaseFilePath Gets or sets the path to where the database files will be copied. (hérité de TransferBase.)
Propriété publique TargetLogFilePath Gets or sets the path to where the log files will be copied. (hérité de TransferBase.)
Propriété publique TemporaryPackageDirectory For internal use only. The value of this property is ignored if set by a caller.
Propriété publique UseDestinationTransaction Gets or sets a value that indicates whether to use the destination transaction. (hérité de TransferBase.)

Haut de la page

Méthodes

  Nom Description
Méthode publique EnumObjects Returns an enumerated list of Uniform Resource Name (URN) values that represent the objects included in the transfer operation. (hérité de TransferBase.)
Méthode publique EnumScriptTransfer Creates a Transact-SQL command batch script used to transfer database objects or database objects and data to another database instance. (hérité de TransferBase.)
Méthode publique Equals (hérité de Object.)
Méthode protégée Finalize (hérité de Object.)
Méthode publique GetHashCode (hérité de Object.)
Méthode publique GetTransferProvider For internal use only. Throws a System.NotSupportedException if invoked by a caller.
Méthode publique GetType (hérité de Object.)
Méthode protégée MemberwiseClone (hérité de Object.)
Méthode protégéeMembre statique ProcessDependencyChain Returns a URN array with options.
Méthode publique ScriptTransfer Creates a Transact-SQL command batch script that creates database objects that are transferred by the transfer operation. (hérité de TransferBase.)
Méthode protégée SetTargetServerInfo Sets the target server version based on the SQL Server version. (hérité de TransferBase.)
Méthode publique ToString (hérité de Object.)
Méthode publique TransferData Transfers data as specified by the Transfer object.

Haut de la page

Événements

  Nom Description
Événement public DataTransferEvent Reports that data has been transferred.
Événement public DiscoveryProgress Marks the progress of the discovery process. (hérité de TransferBase.)
Événement public ScriptingError Reports that an error occurred during the scripting process. (hérité de TransferBase.)
Événement public ScriptingProgress Marks the progress of the scripting process. (hérité de TransferBase.)

Haut de la page

Implémentations d'interfaces explicites

  Nom Description
Implémentation d'interface expliciteMéthode privée ITransferMetadataProvider.GetOptions The ITransferMetadataProvider class represents an interface that implements the transfer metadata process on the referenced connection.
Implémentation d'interface expliciteMéthode privée ITransferMetadataProvider.SaveMetadata Saves metadata when transferring databases across instances.

Haut de la page

Notes

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

Tout membre statique public (Partagé dans Microsoft Visual Basic) de ce type est sûr dans le cadre des opérations à plusieurs threads. Tous les membres de l'instance ne sont pas garantis comme étant thread-safe.  

Exemples

Transfert de données

Sécurité des threads

Tous les membres publics static (Shared dans Visual Basic) de ce type sont thread-safe. Tous les membres de l'instance ne sont pas garantis comme étant thread-safe.

Voir aussi

Référence

Espace de noms Microsoft.SqlServer.Management.Smo