Transfer Object (SQL-DMO)

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.

Remarks

SQL Server provides a database object-scripting and data export and import mechanism to move schema and data from one database to another. 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.

Methods

Events

Properties