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 | |
---|---|---|
Action | Gets or sets a value from the TransferAction enumeration indicating whether the Transfer Database task is copying or moving databases. | |
DestinationConnection | Gets or sets a String containing the name of the SMO connection manager for the destination database. | |
DestinationDatabaseFiles | Gets or sets a String containing the name of the database files for the destination database. | |
DestinationDatabaseName | Gets or sets a String containing the name of the database at the destination. | |
DestinationOverwrite | Gets or sets a Boolean indicating whether the destination database can be overwritten if it exists. | |
ExecutionValue | Overridden. Returns the result of the task execution. | |
Method | Gets or sets a value from the TransferMethod enumeration indicating whether to use Online or Offline transfer method. | |
ReattachSourceDatabase | A Boolean indicating whether the database should be reattached or not. | |
SourceConnection | Gets or sets a String containing the name of the SMO connection manager for the source database. | |
SourceDatabaseFiles | Gets or sets a String containing the names of the source database files to transfer. | |
SourceDatabaseName | Gets or sets a String containing the name of the source database to transfer. | |
Version | Returns the version of the task. This property is read-only. (inherited from Task) | |
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 | |
---|---|---|
CanUpdate | (inherited from Task ) | |
Equals | Overloaded. (inherited from DtsObject ) | |
Execute | Overridden. Runs the task. | |
GetConnectionID | (inherited from Task ) | |
GetConnectionName | (inherited from Task ) | |
GetHashCode | Returns the hash code for this instance. (inherited from DtsObject) | |
GetType | (inherited from Object ) | |
InitializeTask | Overridden. Initializes the properties associated with the task. This method is called by the runtime and is not used in code. | |
LoadFromXML | This method is not callable by your application code. To load a package saved as .xml, use the Application.LoadPackage method. | |
op_Equality | (inherited from DtsObject ) | |
op_Inequality | (inherited from DtsObject ) | |
ReferenceEquals | (inherited from Object ) | |
SaveToXML | This method is not callable by your application code. To save a package as .xml, use the Application.SaveToXml method. | |
ToString | (inherited from Object ) | |
Update | (inherited from Task ) | |
Validate | Overridden. Verifies that the task component is correctly configured. |
위쪽
Protected Methods
이름 | Description | |
---|---|---|
Finalize | (inherited from Object ) | |
MemberwiseClone | (inherited from Object ) |
위쪽
참고 항목
참조
TransferDatabaseTask Class
Microsoft.SqlServer.Dts.Tasks.TransferDatabaseTask Namespace