How To: Copy a DriveWorks 6 Group in SQL Server (KB13010803) (DriveWorks Documentation)

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

SQL Server 2005 Management Studio
SQL Server 2005 Management Studio Express ( http://www.microsoft.com/downloads/details.aspx?FamilyId=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en)
SQL Server 2008 Management Studio
SQL Server 2008 Management Studio Express ( http://www.microsoft.com/downloads/details.aspx?familyid=08E52AC2-1D62-45F6-9A4A-4B76A8564A2B&displaylang=en)

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 1		Start SQL Server Management studio and select the server to which you want to connect.
Step 2		Once 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 3		The "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 8		To restore the database as a copy, right click the "Databases" folder, and click "Restore Database..."
Step 9		The "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 11		To choose the backup to restore, click the "Add" button.
Step 12		Browse for the backup you created earlier, and click "OK"
Step 13		Click "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 17		You will now see both the original database, and a copy in the Object Explorer.