This topic has not yet been rated - Rate this topic

Microsoft.SqlServer.Dts.Tasks.TransferDatabaseTask Namespace

SQL Server 2008

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.

Interfaces

	Interface	Description
	ITransferDatabaseTask	Infrastructure.

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.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD