Export (0) Print
Expand All
Expand Minimize

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.

NoteNote

The Transfer Database task supports SQL Server 2000 and SQL Server. It can transfer a database between instances of SQL Server 2000, instances of SQL Server, and from an instance of SQL Server 2000 to an instance of SQL Server.

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.

NoteNote

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.

Caution noteCaution

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft