Transfer Database Task Editor (Databases Page)
Use the Databases page of the Transfer Database Task Editor dialog box to specify properties for the source and destination databases involved in the Transfer Database task. The Transfer Database task copies or moves a SQL Server database between two instances of SQL Server. This task can also be used to copy a database within the same server. For more information about this task, see Transfer Database Task.
Note
The Transfer Database task supports SQL Server 2000 and SQL Server 2005. It can transfer a database between instances of SQL Server 2000, instances of SQL Server 2005, and from an instance of SQL Server 2000 to an instance of SQL Server 2005.
Options
- SourceConnection
Select a SMO connection manager in the list, or click <New connection...> to create a new connection to the source server.
- DestinationConnection
Select a SMO connection manager in the list, or click <New connection...> to create a new connection to the destination server.
DestinationDatabaseName
Specify the name of the SQL Server database on the destination server.To automatically populate this field with the source database name, specify the SourceConnection and SourceDatabaseName first.
To rename the database on the destination server, type the new name in this field.
DestinationDatabaseFiles
Specifies the names and locations of the database files on the destination server.To automatically populate this field with the source database file names and locations, specify the SourceConnection, SourceDatabaseName, and SourceDatabaseFiles first.
To rename the database files or to specify the new locations on the destination server, populate this field with the source database information, and then click the browse button. In the Destination database files dialog box, edit the Destination File, Destination Folder, or Network File Share.
Note
If you locate the database files by using the browse button, the file location is entered using the local drive notation: for example, c:. You must replace this with the network share notation, including the computer name and share name. If the default administrative share is used, you must use the $ notation, and have administrative access to the share.
DestinationOverwrite
Specify whether the database on the destination server can be overwritten.This property has the options listed in the following table:
Value Description True
Overwrite destination server database.
False
Do not overwrite destination server database.
Warning
The data in the destination server database will be overwritten if you specify True for DestinationOverwrite, which may result in data loss. To avoid this, back up the destination server database to another location before executing the Transfer Database task.
- Action
Specify whether the task will Copy or Move the database to the destination server.
Method
Specify whether the task will be executed while the database on the source server is in online or offline mode.To transfer a database using offline mode, the user that runs the package must be a member of the sysadmin fixed server role.
To transfer a database using the online mode, the user that runs the package must be a member of the sysadmin fixed server role, or the database owner (dbo) of the selected database.
- SourceDatabaseName
Select the name of the database to be copied or moved.
- SourceDatabaseFiles
Click the browse button to select the database files.
ReattachSourceDatabase
Specify whether the task will attempt to reattach the source database if a failure occurs.This property has the options listed in the following table:
Value Description True
Reattach source database.
False
Do not reattach source database.
See Also
Reference
Task Properties UI Reference
Transfer Database Task Editor (General Page)
Expressions Page
Other Resources
Integration Services Error and Message Reference
Integration Services Tasks
SMO Connection Manager