Project Server VME: Plan to upgrade data to Project Server 2010
Applies to: Project Server 2010
Topic Last Modified: 2010-05-19
After you have completed the Project Server virtual migration environment (VME) post-migration phase, you will have successfully migrated your Microsoft Office Project Server 2003 data to Office Project Server 2007 with SP2. You can now move your Office Project Server 2007 databases to your Microsoft Project Server 2010 environment to upgrade your data to Project Server 2010.
Migrating from Project Server 2003 to Project Server 2010 through the VME is a three-step process:
Migrate the data from Project Server 2003 to Office Project Server 2007 with SP2. (This step occurs in the virtual migration environment.)
Move the data from the VME to the Project Server 2010 farm database server.
Upgrade the data from Office Project Server 2007 to Project Server 2010.
The virtual migration environment only migrates the data from Project Server 2003 to Office Project Server 2007 with SP2. To complete the upgrade to Project Server 2010, you must use the database-attach upgrade method to upgrade the Office Project Server 2007 with SP2 databases to Project Server 2010. This requires that you have an installation of Project Server 2010 in your organization.
For more information about installing Project Server 2010, see Deploy Project Server 2010 to a server farm environment.
In this article:
Database-attach upgrade
Create database backups
Migrate to Project Server 2010
Note
For more information about the Project Server virtual migration environment (VME), see Migrate your Project Server 2003 data by using the VME. For more information about upgrading to Project Server 2010, see Project Server 2010 upgrade overview.
Database-attach upgrade
Migrating your data from the VME to Project Server 2010 requires you to use the database-attach upgrade method. A database-attach upgrade lets you "attach" restored copies of your Office Project Server 2007 databases to a new Project Server 2010 installation. Office Project Server 2007 farm databases are backed up and then restored on the computer that is running Microsoft SQL Server that is hosting the Project Server 2010 databases. The new Project Server 2010 farm points to these restored databases when the Microsoft Project Web App instance is created. When you connect to the databases from the new Project Server 2010 instance, the databases are upgraded to Project Server 2010.
There are two variations of the database-attach upgrade:
Database attach full: Upgrades the four Office Project Server 2007 databases and the content database that contains the Project Web App site data. Use this method if you also want to migrate your project workspace data.
Database attach core: Upgrades only the four Office Project Server 2007 databases. Use this method if you do not want to migrate your project workspace data.
A database-attach full upgrade requires the following databases from the Office Project Server 2007 farm:
ProjectServer_Archive
ProjectServer_Draft
ProjectServer_Published
ProjectServer_Reporting
Windows SharePoint Services 3.0 content database containing the project workspace data
A database-attach core upgrade requires the following Office Project Server 2007 databases from the farm:
ProjectServer_Archive
ProjectServer_Draft
ProjectServer_Published
ProjectServer_Reporting
Note
For more information about database-attach upgrades, see Project Server 2010 upgrade overview.
Create database backups
You have to create database backups of the required databases in SQL Server 2005 on the VME, as described in the following procedure:
To back up a database in SQL Server 2005
On the VME virtual machine, open SQL Server Management Studio.
In the Connect to Server dialog box, click Connect.
In SQL Server Management Studio, in Object Explorer, expand Databases. Right-click the database that you want to back up, click Tasks, and then click Back Up. The Back Up Database dialog box appears.
In the Back Up Database dialog box, in the Source section, in the Database field, verify that the database name is the one for which you want to create a backup.
In the Backup type field, select Full.
In the Backup component field, select Database.
In the Backup set section, in the Name field, either accept the default backup set name that is suggested or type a different name for the backup set.
In the Destination section, select Disk, and then specify a destination to which you want to save the backup file.
Click OK to start the backup process.
Repeat the procedure to back up the remaining required databases.
Migrate to Project Server 2010
After you have created database backups of your required databases, move the copies from the VME to the computer that is running SQL Server that is hosting the Project Server 2010 databases. If the VME virtual machine is not on the network, you can transfer the files through an internal virtual network between the VME and the computer that hosts the VME virtual machine. This was established previously when you transferred Project Server 2003 data from the virtual machine host to the VME virtual machine. For more information, see Load data to the Project Server VME).
The following articles describe how to migrate your Office Project Server 2007 databases to Project Server 2010 to complete your migration from Project Server 2003. Choose the right method for you and follow the procedures in that article: