How to upgrade your existing Microsoft Project VPC running on SQL 2005 to SQL Server 2008
I’m sure you have seen these cool SQL Reporting Services 2008 reports: Microsoft SQL Server Reporting Services 2008 – Sample Project Server Reports and would like to do the same in your favorite EPM demo VPC or you just have plenty of free time during this time of the year and you are looking for a fun project, hence please find below the steps to upgrade an existing image running on SQL 2005 to SQL 2007 (should take about two hours depending on hardware):
| Download SQL Server 2008 Developer (x86, x64, ia64) - DVD (English) using your MSDN Subscription. Start your favorite EPM image using your favorite virtualization production Hyper-V and mount the ISO downloaded. |  |
SQL Server 2008 Setup requires two updates prior to install:
|
 |
| .NET Framework 3.5 SP1 Setup |  |
| One pre-requisite is to have the latest version of Windows Installer 4.5 ( KB942288-v4 ); install and reboot |  |
| Start Upgrade Wizard |  |
| Setup Support Rule are run successfully |  |
| Choose the Instance to Upgrade |  |
| All Upgrade Rules are passed successfully, start upgrade process (it took about 90min on Dell Precision 690) |  |
| Upgrade Progress finished successfully |  |
Download and install the following components from the Feature Pack for Microsoft SQL Server 2005 - December 2008 (all X86 Package in this case):
These components are required to properly configure the Cube Building process. |
 |
| Rebuilt your cube and voila! | |
Related Links |