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.
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:
Note The Transfer object is compatible with instances of SQL Server 2000 and SQL Server version 7.0. However, the Transfer2 object extends the functionality of the Transfer object for use with features that are new in SQL Server 2000.