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.

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.

[!참고]

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