SQL-DMO

Transfer Object

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.

Properties
CopyAllDefaults Property DestLogin Property
CopyAllObjects Property DestPassword Property
CopyAllRules Property DestServer Property
CopyAllStoredProcedures Property DestUseTrustedConnection Property
CopyAllTables Property DropDestObjectsFirst Property
CopyAllTriggers Property IncludeDependencies Property
CopyAllUserDefinedDatatypes Property IncludeLogins Property
CopyAllViews Property IncludeUsers Property
CopyData Property Script2Type Property
CopySchema Property ScriptType Property
DestDatabase Property  

Methods
Abort Method AddObjectByName Method
AddObject Method ListObjectNames Method

Events
PercentCompleteAtStep Event StatusMessage Event
ScriptTransferPercentComplete Event TransferPercentComplete Event

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:

See Also

Transfer2 Object