Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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
| Name | Description | |
|---|---|---|
| TransferDatabaseTask | Initializes a new instance of the TransferDatabaseTask class. |
Top
Public Properties
| Name | Description | |
|---|---|---|
.gif "ms215028.pubproperty(en-US,SQL.90).gif") |
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) |
Top
Public Methods
(see also Protected Methods )
| Name | Description | |
|---|---|---|
.gif "ms215028.pubmethod(en-US,SQL.90).gif") |
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. |
.gif "ms215028.static(en-US,SQL.90).gif") |
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. |
Top
Protected Methods
| Name | Description | |
|---|---|---|
.gif "ms215028.protmethod(en-US,SQL.90).gif") |
Finalize | (inherited from Object ) |
|
MemberwiseClone | (inherited from Object ) |
Top
See Also
Reference
TransferDatabaseTask Class
Microsoft.SqlServer.Dts.Tasks.TransferDatabaseTask Namespace