Project Server 2010 - Visual Upgrade

When you upgrade a Project Server 2007 instance to 2010 the project workspaces actually come across with the exact same look and feel as they were in the 2007 enviornment. As part of this upgrade, you can choose to perform a visual upgrade on any individual web (project site). This option can be found under Site Actions>Site Settings menu. Then click on the 'Title, description and icon' link. Down the bottom right corner, there are three options. Now this is off the top of my head but if i get time to double check the exact wording, I'll update this post later.

1. Leave - Keeps the site look and feel in the previous 2007 format.
2. Preview visual upgrade - Lets you view the site if it were upgraded but does not commit the setting.
3. Commit visual upgrade - Doing this removes these three options permenately but apparently you can revers this action via PowerShell if you need. A bit of bing magic should find the exact syntax you require.

Now this is handy to know but what if you had just upgraded a Project Server environment containing over 500 sites. Would I have to upgrade each project site individually? The answer, thankfully, is no. You can find a visual upgrade setting at the site collection level (Site Actions>Site Settings>Visual Upgrade of the base site collection site). By setting the upgrade here, it will cascade the visual upgrade to all sub web of the site collection. Very handy to know for those big upgrades.

Project Server 2007 to 2010 Upgrade

Something to share today. When migrating a content Project 2007 content database, I discovered the SharePoint content database which contains all the project sites would not upgrade if you already have an existing instance in the same destination SharePoint farm.

The scenario was I upgrded the content database in its own web application. Worked perfectly. Then for another test I created a brand new web application, restored another copy of the 2007 content database into SQL. Then ran the stsadm -o addcontentdb command to upgrade the content database. After it completes (with errors, but this is normal) I notice the site collection did not upgrade. Further investigation showed it did not even register according to the SharePoint GUI in Central Administration. This would continue to fail until I actually removed the previous web application

Now this is pure speculation but i suspect the issue is because the SharePoint sites come accross with their existing unique identifiers (GUIDs) and SharePoint may sense these IDs are already in use and therfore discards them in the second instance upgrade. Now, you may think, WOW, that's amazing Piet! but let's face it why on earth would you want to do this in a real world scenario anyway? Well I did and thought it may be handy to know for someone else experimenting with Project Server upgrades.