Transfer Object

この機能は、将来のバージョンの Microsoft SQL Server では削除される予定です。新規の開発作業ではこの機能を使用しないようにし、現在この機能を使用しているアプリケーションは修正することを検討してください。

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-DMO オブジェクト モデル

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

解説

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.
ms141234.note(ja-jp,SQL.90).gifメモ :
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.

参照

関連項目

Transfer2 Object

ヘルプおよび情報

SQL Server 2005 の参考資料の入手