DriveWorks Pro 15: How To: Copy a DriveWorks 6 Group in SQL Server (KB13010803) [send feedback...]

Introduction

This document will show you how to use SQL Server Management Studio to copy a DriveWorks 6 group ready for DriveWorks 7 migration.

Applies To:

  • Microsoft SQL Server 2005
  • Microsoft SQL Server Express 2005
  • Microsoft SQL Server 2008
  • Microsoft SQL Server Express 2008

Prerequisites

To perform the steps in this document you will need one of the SQL Server Management Studio editions mentioned in the Applies To section. This guide uses the SQL Server 2005 Management Studio Express edition, which is freely available from the link given in the Applies To section.

To connect to SQL Server 2008 or SQL Server Express 2008 you will need one of the 2008 editions (or later) of the Management Studio.
To connect to SQL Server 2005 or SQL Server Express 2005 you can use any of the listed (or later) versions of the Management Studio.

Overview

There are a number of ways of copying a database in SQL Server. The method used in this document is to backup the database, and restore it with a new name. This method works across all SQL Server editions and is simple to perform.

Steps

If you are working with a database on a server managed by an IT department, make sure you consult your IT department before following any of these steps.

Step 1Start SQL Server Management studio and select the server to which you want to connect.
Step 2Once you are connected, you should see a screen similar to the one on the left, expand the "Databases" folder, and right click the database to copy. Expand the "Tasks" menu, and click "Back Up..."
Step 3The "Back Up Database" dialog appears similar to the one on the left.
Step 4

Remove any backup destinations in the list at the bottom of the dialog by clicking them in the list and then clicking the "Remove" button.

Click "Add.."

Step 5

Browse for a location to save the backup and then click "OK"

Step 6

When you have performed the steps above, your dialog should resemble the one on the left.

Click "OK" to start the backup.

Step 7

The backup will complete and you will get a dialog similar to the one on the left.

Step 8To restore the database as a copy, right click the "Databases" folder, and click "Restore Database..."
Step 9The "Restore Database" dialog appears as shown on the left.
Step 10

Enter a name for the copied database in the "To database" text box, e.g. "Pressure Vessel 7"

Select "From device" and then click the button to the right of it ("...").

Step 11To choose the backup to restore, click the "Add" button.
Step 12Browse for the backup you created earlier, and click "OK"
Step 13Click "OK" again to load the backup information into the restore dialog.
Step 14

Click the checkbox to the left of the backup that appears in the list at the bottom of the "Restore Database" dialog.

Step 15

When you have performed the steps above, your dialog should resemble the one on the left.

Click "OK" to start the restore operation.

Step 16

The restore will complete, and a dialog like the one on the left will appear.

Click "OK"

Step 17You will now see both the original database, and a copy in the Object Explorer.


Knowledge Base Article Ref:KB13010803

Table of Contents