Project Server 2007 migration to Project Server 2013 by exporting/importing files? RRS feed

  • Question

  • I have been told by a colleague that it is possible to migrate from Project Server 2007 to Project Server 2013 without the need to migrate through Project Server 2010. This is supposedly possible by exporting the PS2007 files and then directly importing them into PS2013. Microsoft's approach is very database-centric and we are trying to perform this migration as quickly and painlessly as possible. I understand that the .PWA won't migrate this way so my colleague suggested just rebuilding them.

    The 2007 environment is quite large (about 250GB with 6 years of archived data) and the installation is quite heavily customized. I would love to know if anyone has migrated 2007 to 2013 this way, and what gotchas might be encountered. Thanks in advance!

    Thursday, August 20, 2015 8:47 PM

All replies

  • Hi,

    First of all I'd say that migrating from 2007 to 2013 is not a simple easy and quick operation. It should be considered as an IT system migration project. Even more if you do have customizations and a lot of projects. Note also that there is a large technological and fonctionality gap between 2007 and 2013 versions, with some corner stone new features such as PDP, EPT, departments...

    Thus I'd recommend to collect the business requirements since there might be new ones, to build a Project Server 2013 proof of concept to understand the new features, to audit your 2007 instance with any customizations, reports... And eventually to contact one of your local Microsoft Partners who can help you doing such a migration in the best possible way, since most of us have done it several times.

    For the database part, you have to first migrate to a 2010 environment and then 2013.

    Hope this helps,

    Guillaume Rouyre, MBA, MVP, P-Seller |

    Friday, August 21, 2015 7:13 AM
  • In addition to Guillaume answer, I would add you cannot skip this step.  However, you mention that the site is heavily customized and my gut feeling is that the migration will not work or that you will lose a some data.  I have done over 10 migrations and there is a lot of garbage that gets collected since 2007 and if service packs have not been up to date for PS2007, their are a loads of other issues, you will be contending with.

    My suggestion would be

    1) Configure PWA to the point you are satisfied that this is the configuration you want to use after migration occurs.

    2) Rebuild your resource pool of active resources. Export / import resources.  Use a PowerShell script or something to make this consistent for the day of switch over.

    3) Active projects are exported/imported into new system.

    4) Switchover day/week.  Do steps 2 and 3

    5) Archive the whole PS2007 in a VM for historical purposes

    Michael Wharton, MVP, MBA, PMP, MCT, MCTS, MCSD, MCSE+I, MCDBA
    Blog contains my field notes and SQL queries

    Sunday, August 23, 2015 1:02 PM