TransferDatabaseTask Members
Include Protected Members
Include Inherited 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 TransferDatabaseTask type exposes the following members.
Constructors
Name | Description | |
---|---|---|
![]() |
TransferDatabaseTask() | Initializes a new instance of the TransferDatabaseTask class. |
Top
Methods
Name | Description | |
---|---|---|
![]() |
CanUpdate(String) | *** Member deprecated; see Remarks. *** A Boolean that indicates whether the new package XML can update the old package XML. (Inherited from Task.) |
![]() |
Equals(Object) | Determines whether two object instances are equal. (Inherited from DtsObject.) |
![]() |
Execute(Connections, VariableDispenser, IDTSComponentEvents, IDTSLogging, Object) | Runs the task. (Overrides Task.Execute(Connections, VariableDispenser, IDTSComponentEvents, IDTSLogging, Object).) |
![]() |
Finalize() | (Inherited from Object.) |
![]() |
GetConnectionID(Connections, String) | Gets a String containing the ID of the connection. (Inherited from Task.) |
![]() |
GetConnectionName(Connections, String) | Gets a String containing the name of the connection. (Inherited from Task.) |
![]() |
GetHashCode() | Returns the hash code for this instance. (Inherited from DtsObject.) |
![]() |
GetType() | (Inherited from Object.) |
![]() |
InitializeTask(Connections, VariableDispenser, IDTSInfoEvents, IDTSLogging, EventInfos, LogEntryInfos, ObjectReferenceTracker) | Initializes the properties associated with the task. This method is called by the runtime and is not used in code. (Overrides Task.InitializeTask(Connections, VariableDispenser, IDTSInfoEvents, IDTSLogging, EventInfos, LogEntryInfos, ObjectReferenceTracker).) |
![]() |
LoadFromXML(XmlElement, IDTSInfoEvents) | This method is not callable by your application code. To load a package saved as .xml, use the Application.LoadPackage method. |
![]() |
MemberwiseClone() | (Inherited from Object.) |
![]() |
SaveToXML(XmlDocument, IDTSInfoEvents) | 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(String%) | *** Member deprecated; see Remarks. *** This method updates the old package XML with the new package XML if CanUpdate is set to true. (Inherited from Task.) |
![]() |
Validate(Connections, VariableDispenser, IDTSComponentEvents, IDTSLogging) | Verifies that the task component is correctly configured. (Overrides Task.Validate(Connections, VariableDispenser, IDTSComponentEvents, IDTSLogging).) |
Top
Properties
Name | 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 | Returns the result of the task execution. (Overrides Task.ExecutionValue.) |
![]() |
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 | *** Member deprecated; see Remarks. *** Returns the version of the task. This property is read-only. (Inherited from Task.) |
Top