TransferDatabaseTask Class
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.
Assembly: Microsoft.SqlServer.TransferDatabasesTask (in Microsoft.SqlServer.TransferDatabasesTask.dll)
Microsoft.SqlServer.Dts.Runtime::DtsObject
Microsoft.SqlServer.Dts.Runtime::Task
Microsoft.SqlServer.Dts.Tasks.TransferDatabaseTask::TransferDatabaseTask
| Name | Description | |
|---|---|---|
![]() | TransferDatabaseTask() | Initializes a new instance of the TransferDatabaseTask class. |
| Name | 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 | Returns the result of the task execution.(Overrides Task::ExecutionValue.) |
![]() | 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. |
![]() | TargetServerVersion | (Inherited from Task.) |
![]() | Version | *** Member deprecated; see Remarks. *** Returns the version of the task. This property is read-only.(Inherited from Task.) |
The transfer can occur between databases of the same version, or to a higher version. For more information, see Transfer Database Task.
Any public static ( Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

