다음을 통해 공유


TransferDatabaseTask Members

Allows the transfer of a database between a source and a destination server using two different methods: database online, and database offline. The task requires the use of an SMO Connection Manager.

The following tables list the members exposed by the TransferDatabaseTask type.

Public Constructors

  이름 Description
TransferDatabaseTask Initializes a new instance of the TransferDatabaseTask class.

위쪽

Public Properties

  이름 Description
ms215028.pubproperty(ko-kr,SQL.90).gif Action Gets or sets a value from the TransferAction enumeration indicating whether the Transfer Database task is copying or moving databases.
ms215028.pubproperty(ko-kr,SQL.90).gif DestinationConnection Gets or sets a String containing the name of the SMO connection manager for the destination database.
ms215028.pubproperty(ko-kr,SQL.90).gif DestinationDatabaseFiles Gets or sets a String containing the name of the database files for the destination database.
ms215028.pubproperty(ko-kr,SQL.90).gif DestinationDatabaseName Gets or sets a String containing the name of the database at the destination.
ms215028.pubproperty(ko-kr,SQL.90).gif DestinationOverwrite Gets or sets a Boolean indicating whether the destination database can be overwritten if it exists.
ms215028.pubproperty(ko-kr,SQL.90).gif ExecutionValue Overridden. Returns the result of the task execution.
ms215028.pubproperty(ko-kr,SQL.90).gif Method Gets or sets a value from the TransferMethod enumeration indicating whether to use Online or Offline transfer method.
ms215028.pubproperty(ko-kr,SQL.90).gif ReattachSourceDatabase A Boolean indicating whether the database should be reattached or not.
ms215028.pubproperty(ko-kr,SQL.90).gif SourceConnection Gets or sets a String containing the name of the SMO connection manager for the source database.
ms215028.pubproperty(ko-kr,SQL.90).gif SourceDatabaseFiles Gets or sets a String containing the names of the source database files to transfer.
ms215028.pubproperty(ko-kr,SQL.90).gif SourceDatabaseName Gets or sets a String containing the name of the source database to transfer.
ms215028.pubproperty(ko-kr,SQL.90).gif Version  Returns the version of the task. This property is read-only. (inherited from Task)
ms215028.pubproperty(ko-kr,SQL.90).gif WaitForMe  Returns a Boolean that indicates whether the parent container should wait for completion of this task. This property is read-only. (inherited from Task)

위쪽

Public Methods

(see also Protected Methods )

  이름 Description
ms215028.pubmethod(ko-kr,SQL.90).gif CanUpdate  (inherited from Task )
ms215028.pubmethod(ko-kr,SQL.90).gif Equals  Overloaded. (inherited from DtsObject )
ms215028.pubmethod(ko-kr,SQL.90).gif Execute Overridden. Runs the task.
ms215028.pubmethod(ko-kr,SQL.90).gif GetConnectionID  (inherited from Task )
ms215028.pubmethod(ko-kr,SQL.90).gif GetConnectionName  (inherited from Task )
ms215028.pubmethod(ko-kr,SQL.90).gif GetHashCode  Returns the hash code for this instance. (inherited from DtsObject)
ms215028.pubmethod(ko-kr,SQL.90).gif GetType  (inherited from Object )
ms215028.pubmethod(ko-kr,SQL.90).gif InitializeTask Overridden. Initializes the properties associated with the task. This method is called by the runtime and is not used in code.
ms215028.pubmethod(ko-kr,SQL.90).gif LoadFromXML This method is not callable by your application code. To load a package saved as .xml, use the Application.LoadPackage method.
ms215028.pubmethod(ko-kr,SQL.90).gifms215028.static(ko-kr,SQL.90).gif op_Equality  (inherited from DtsObject )
ms215028.pubmethod(ko-kr,SQL.90).gifms215028.static(ko-kr,SQL.90).gif op_Inequality  (inherited from DtsObject )
ms215028.pubmethod(ko-kr,SQL.90).gifms215028.static(ko-kr,SQL.90).gif ReferenceEquals  (inherited from Object )
ms215028.pubmethod(ko-kr,SQL.90).gif SaveToXML This method is not callable by your application code. To save a package as .xml, use the Application.SaveToXml method.
ms215028.pubmethod(ko-kr,SQL.90).gif ToString  (inherited from Object )
ms215028.pubmethod(ko-kr,SQL.90).gif Update  (inherited from Task )
ms215028.pubmethod(ko-kr,SQL.90).gif Validate Overridden. Verifies that the task component is correctly configured.

위쪽

Protected Methods

  이름 Description
ms215028.protmethod(ko-kr,SQL.90).gif Finalize  (inherited from Object )
ms215028.protmethod(ko-kr,SQL.90).gif MemberwiseClone  (inherited from Object )

위쪽

참고 항목

참조

TransferDatabaseTask Class
Microsoft.SqlServer.Dts.Tasks.TransferDatabaseTask Namespace