sql Server database copy tool

Use the Copy Database Wizard
October 12, 2017 – 09:58 am
How to Copy an SQL Server Database with Copy Database Wizard

Select the database(s) you want to move or copy from the source server to the destination server. See at the top of topic.

Move
Move the database to the destination server.

Copy
Copy the database to the destination server.

Source
Displays the databases that exist on the source server.

Status
Displays various information of the source database.

Refresh
Refresh the list of databases.

Configure destination database

Change the database name if appropriate and specify the location and names of the database files. This page appears once for each database being moved or copied.

Source Database
The name of the source database. The text box is not editable.

Destination Database
The name of the destination database to be created, modify as desired.

Destination database files:

Filename
The name of the destination database file to be created, modify as desired.

Size (MB)
Size of the destination database file in megabytes.

Destination Folder
The folder on the destination server to host the destination database file, modify as desired.

Status
Status

If the destination database already exists:
Decide what action to take if the destination database already exists.

Stop the transfer if a database or file with the same name exists at the destination.

Drop any database on the destination server with the same name, then continue with the database transfer, overwriting existing database files.

Source: docs.microsoft.com
Related Posts