• Article

Load data to the Project Server VME

 

Applies to: Project Server 2010

Topic Last Modified: 2011-01-14

This article describes how to move the Microsoft Office Project Server 2003 data from the virtual machine host to the Project Server virtual migration environment (VME) virtual machine. Before doing procedures in this article you must have created a backup copy of your Project Server 2003 databases and established data exchange between the host computer and the VME virtual machine. These procedures are described in the following two articles:

This article describes:

  • Move Project Server 2003 database backups to the VME virtual machine

  • Restore your database to the VME virtual machine

This article is one of several tasks required to configure your Hyper-V environment for the Project Server virtual migration environment (VME). For more information about other tasks required to configure the Hyper-V environment, see Configure the Hyper-V environment for the Project Server VME. For more information about the VME, see Overview of the VME for Project Server 2010.

Move Project Server 2003 database backups to the VME virtual machine

Use the following procedure to create a share on the Project Server VME and to move the backup copies of your Project Server 2003 databases from the virtual machine host to the VME virtual machine.

Note

If the following procedure requires you to enter credentials for the VME virtual machine, the domain and User ID are "VME\Administrator", and the password is "pass@word1".

Move Project Server 2003 database backups to the VME

  1. On the VME virtual machine, open a Command Prompt window and run the command IPConfig. Notice the Autoconfiguration IPv4 Address specified there.

  2. On the Hyper-V host machine, click Start, and then click Run. In the Open field, type \\<IP Address of the VME virtual machine>\E$. For "IP Address of the VME virtual machine", use the Autoconfiguration IPv4 Address that you noted in the previous step. If you are prompted for your credentials, enter the credentials for the VME virtual machine listed earlier. (The Domain\Username is “VME\Administrator”, and the password is "pass@word1".)

  3. In Windows Explorer, click New folder and create a folder in the root of the E drive of the VME virtual machine and give it a name (for example, "ProjectServerData").

  4. In Windows Explorer, copy the backup copies of your Project Server 2003 database or databases from the location they are stored at. Paste them to the folder you have just created on the E drive of the VME virtual machine in the previous step. If you are migrating the project workspace data, also copy your backup of the Windows SharePoint Services 2.0 databases that contain your project workspace data to the folder.

Restore your database to the VME virtual machine

After copying backups of the Project Server 2003 database (or databases) to the VME virtual machine, use the following procedure to restore the database or databases to Microsoft SQL Server 2005 on the VME virtual machine.

Restore the database to the VME

  1. In Hyper-V Manager, switch to the VME virtual machine.

  2. Click Start, click All Programs, click Microsoft SQL Server 2005, and then click SQL Server Management Studio.

  3. On the Connect to Server dialog box, click Connect.

  4. On the Microsoft SQL Server Management Studio page, in the Object Explorer section, right-click Databases, and then click Restore Database.

  5. On the Restore Database page, in the Destination to restore section, in the To database field, type Project2003SourceDB.

    Important

    When restoring your databases, verify that you are renaming them to the exact name specified in the procedures. The migration tool configuration file and the optional migration scripts need the database names to be accurate to function correctly.

  6. In the Source for restore section, to the right of the From device option button, click the ellipsis (…) button.

  7. In the Specify Backup dialog box, click Add.

  8. Select the folder on the E drive to which you copied the database backups and select the Project Server 2003 database backup file. Click OK. On the Specify Backup page, click OK again.

  9. In the Select the backup sets to restore list, click the check box in the Restore column.

  10. Click OK. Your database will be restored.

If the Project Server 2003 database is partitioned into two separate databases, you also must restore the Project Web database (default name “Project2003WebTablesDB”). Run through the step again to restore this database. Make sure to restore this database to the name Project2003SourceWebDB. Again note that it is important to restore the Project Web database to this exact name.

Note

If you are migrating the Project Server 2003 workspace data, read the directions first. See Project Server VME: Restore your project workspace data for more information before attempting to restore the Windows SharePoint Services 2.0 content database that contains your project workspace data.