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.

ClassDescription
TransferDatabaseTaskAllows 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.DtsTransferDBExceptionThe exception that is thrown at load time if the persisted name of the XML root node of the task is corrupt.

InterfaceDescription
ITransferDatabaseTask 

EnumerationDescription
TransferActionUsed by the Action property to determine if the transfer is a copy or a move.
TransferMethodUsed by the TransferDatabaseTask to determine whether the move or copy will occur in online mode or offline mode.

Community Additions

ADD
Show: