Migrating PS2007 with SQL Server 2008 to PS2010 with Sql Server 2012 RRS feed

  • Question

  • Issue: Migration from Project Server 2007 to Project Server 2010

    Migration approach : Database attach core group to Project Server 2010 (URL :

    Step1 : Backup Project Server 2007 core database (Draft, Archive, Publish, Report) from MS SQL Server 2008.

    Step2:  Setup Single Box Environment

                  Windows 2008 R2

                  MS SQL Server 2012

                  SharePoint 2010

                 Project Server 2010

    Step 3: Restore Project Server 2007 Core databases (Draft, Archive, Publish, Report)  in MS SQL Server 2012.

    Step 4. Restoration activity successfully completed.

    Step 5: Create PWA from SharePoint 2012 Central Admin Step 6: During provision process it failed.

    I didi visited relavant posts but they do not say "why" it happen, Only commonanlities I find is log a case with MS and it was resolved.

    Please guide me.

    Friday, June 22, 2012 10:40 AM

All replies

  • Hi there,

    Did you also take the content database from the PS 2007 farm that contains the PWA site collection to the PS2010 farm and attach this to the 2010 web application where you are provisioning the PWA site in 2010?



    Paul Mather | Twitter |

    Friday, June 22, 2012 10:55 AM
  • Hi,

    Did kind of error did you reviece when provision failed in the eventlog or ULS logs? If you provide this information we are better equiped to help you with your problem.

    With kind regards,

    Robin Kruithof

    Technical Consultant EPM

    Friday, June 22, 2012 11:12 AM