• Article

Project Server VME: Restore your project workspace data

 

Applies to: Project Server 2010

Topic Last Modified: 2010-10-05

Warning

This step is optional and is only required if you are migrating the Microsoft Office Project Server 2003 project workspace data.

The Project Server 2003 project workspace data is contained in a Windows SharePoint Services 2.0 content database on the computer that is running Microsoft SQL Server and that is hosting your Project Server 2003 farm environment. Windows SharePoint Services 2.0 was an optional application that you could install with Project Server 2003. It allowed for the creation of project workspaces in Project Server 2003. All data (issues, risks, and documents stored in the project workspaces, as well as associations between the Project items and Windows SharePoint Services 2.0 items) are stored to a Windows SharePoint Services 2.0 content database. If you want to migrate your project workspace data to Microsoft Project Server 2010, this database must be restored and migrated to Windows SharePoint Services 3.0. The Project Server virtual migration environment (VME) allows you to do this.

This article describes the two steps in restoring your project workspace content database to the VME virtual machine:

  • Run the Pre-Upgrade Pre-scan tool on your Windows SharePoint Services 2.0 content database

  • Move the Windows SharePoint Services 2.0 content database to the VME

This article describes one of several tasks required to configure your Hyper-V environment for the Project Server virtual migration environment. For more information about other tasks required to configure your 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.

Run the Pre-scan tool on your Windows SharePoint Services 2.0 content database

Prior to migrating the project workspace sites and their content to Windows SharePoint Services 3.0, we recommend that you use the Pre-scan tool to validate the Windows SharePoint Services 2.0 content database that contains the project workspaces.

In addition, if customization has been applied to site templates or objects, the Pre-scan utility validates whether they are compatible with Windows SharePoint Services 3.0.

Important

This must be done in the Project Server 2003 environment. It should not be done in the VME.

To run Pre-scan

  1. Download the Pre-Scan utility from the SharePoint Products and Technologies Utility: Upgrade Pre-scan Tool page on the Microsoft Download Center. Download the file named Prescan.exe to the server running Windows SharePoint Services 2.0.

  2. Open a Command Prompt window and run the following command: Prescan.exe /all

  3. When the process is complete, "Operation Completed Successfully" appears.

For more information about running the Pre-scan utility, see the "Prescan.exe ReadMe" document available from the same download page. (The file name is Prescan.doc.)

View the following articles if you encounter any problems when running the Pre-Scan tool:

Move the Windows SharePoint Service 2.0 content database to the VME

After running Pre-scan, make a backup copy of the content database containing your project workspace data. You can use the procedures in Project Server VME: Create a backup of the existing Project Server 2003 database to create a backup of the Windows SharePoint Services 2.0 content database. After making the backup copy of the database, move the backup copy of the database to the VME virtual machine, and then restore the database in Microsoft SQL Server 2005. Use the procedures described in Load data to the Project Server VME to move the database to the VME virtual machine, and to restore the database in SQL Server 2005. Make sure to restore the content database to a unique database name.

For more information about migrating your Windows SharePoint Services 2.0 content database to Windows SharePoint Services 3.0 in the virtual migration environment, see the "Full Migration from Windows SharePoint Services 2.0 (to a different computer)" section of Upgrade project workspaces from Project Server 2003.

For additional documentation about Microsoft SharePoint Server migration and upgrade, see the \SharePoint folder on the E drive of the VME. To view the content, you must first click Click I Accept at bottom to start - MigrationEULA (located in the “Migrate SharePoint” folder) to accept the licensing agreement.