Partager via


Transfer Object

Cette fonctionnalité sera supprimée dans une prochaine version de Microsoft SQL Server. Évitez d'utiliser cette fonctionnalité dans de nouveaux travaux de développement et prévoyez de modifier les applications qui utilisent actuellement cette fonctionnalité.

The Transfer object is used as a parameter for methods of the Database object. The Transfer object defines schema and data elements moved from one Microsoft SQL Server database to another.

Modèle objet SQL-DMO qui affiche l'objet en cours

Notes

SQL Server provides a database object-scripting and data export and import mechanism to move schema and data from one database to another. SQL Distributed Management Objects (SQL-DMO) provides access to the database-transfer utility through the Transfer object and the ScriptTransfer and Transfer methods of the Database object.

With the Transfer object, you can:

  • Identify schema or data to move from one SQL Server database to another.

  • Identify the destination for schema and data transferred.

  • Monitor the progress of the ScriptTransfer and Transfer methods of the Database object.

  • Stop an in-progress database-to-database transfer operation.

Notes

The Transfer object is compatible with instances of and SQL Server versions 7.0 and later. However, the Transfer2 object extends the functionality of the Transfer object for use with features that were introduced in SQL Server 2000.

Voir aussi

Référence