TransferDatabaseTask Members
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.
The following tables list the members exposed by the TransferDatabaseTask type.
Public Constructors
Nome | Description | |
---|---|---|
TransferDatabaseTask | Initializes a new instance of the TransferDatabaseTask class. |
Torna all'inizio
Public Properties
Nome | 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 | Overridden. Returns the result of the task execution. |
![]() |
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. |
![]() |
Version | Returns the version of the task. This property is read-only. (inherited from Task) |
![]() |
WaitForMe | Returns a Boolean that indicates whether the parent container should wait for completion of this task. This property is read-only. (inherited from Task) |
Torna all'inizio
Public Methods
(see also Protected Methods )
Nome | Description | |
---|---|---|
![]() |
CanUpdate | (inherited from Task ) |
![]() |
Equals | Overloaded. (inherited from DtsObject ) |
![]() |
Execute | Overridden. Runs the task. |
![]() |
GetConnectionID | (inherited from Task ) |
![]() |
GetConnectionName | (inherited from Task ) |
![]() |
GetHashCode | Returns the hash code for this instance. (inherited from DtsObject) |
![]() |
GetType | (inherited from Object ) |
![]() |
InitializeTask | Overridden. Initializes the properties associated with the task. This method is called by the runtime and is not used in code. |
![]() |
LoadFromXML | This method is not callable by your application code. To load a package saved as .xml, use the Application.LoadPackage method. |
![]() ![]() |
op_Equality | (inherited from DtsObject ) |
![]() ![]() |
op_Inequality | (inherited from DtsObject ) |
![]() ![]() |
ReferenceEquals | (inherited from Object ) |
![]() |
SaveToXML | This method is not callable by your application code. To save a package as .xml, use the Application.SaveToXml method. |
![]() |
ToString | (inherited from Object ) |
![]() |
Update | (inherited from Task ) |
![]() |
Validate | Overridden. Verifies that the task component is correctly configured. |
Torna all'inizio
Protected Methods
Nome | Description | |
---|---|---|
![]() |
Finalize | (inherited from Object ) |
![]() |
MemberwiseClone | (inherited from Object ) |
Torna all'inizio
Vedere anche
Riferimento
TransferDatabaseTask Class
Microsoft.SqlServer.Dts.Tasks.TransferDatabaseTask Namespace