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
Public class 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.
Public class TransferDatabaseTask.DtsTransferDBException The exception that is thrown at load time if the persisted name of the XML root node of the task is corrupt.

Interfaces

  Interface Description
Public interface ITransferDatabaseTask Infrastructure.

Enumerations

  Enumeration Description
Public enumeration TransferAction Used by the Action property to determine if the transfer is a copy or a move.
Public enumeration TransferMethod Used by the TransferDatabaseTask to determine whether the move or copy will occur in online mode or offline mode.