Microsoft.SqlServer.Dts.Tasks.TransferDatabaseTask Namespace
The Microsoft.SqlServer.Dts.Tasks.TransferDatabaseTask namespace contains classes and enumerations that allow the transfer of databases between a source and a destination server using two different methods: database online, and database offline. The task requires the use of a SMO connection.
Classes
Class | Description | |
---|---|---|
![]() |
TransferDatabaseTask | 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. |
![]() |
TransferDatabaseTask.DtsTransferDBException | The exception that is thrown at load time if the persisted name of the XML root node of the task is corrupt. |
Enumerations
Enumeration | Description | |
---|---|---|
![]() |
TransferAction | Used by the Action property to determine if the transfer is a copy or a move. |
![]() |
TransferMethod | Used by the TransferDatabaseTask to determine whether the move or copy will occur in online mode or offline mode. |