Upgrading Project Server 2003 to Project Server 2007

Few days back I was looking for ways to upgrade Project Server 2003 to PS 2007 but there is no step by step guide on how to do that.  During the holidays I got a chance to do a test migration and create a step by step guide.  I hope this guide will help people do Project Server migration hands on

  1. Login with domain or local Administrator
  2. Install Windows Server 2003 Service pack 1 or two

  1. Click Next

  1. Click I Agree and click Next

The complete document can be found

Upgrading Project Server 2003 to Project Server 2007

In Case any one has questions please feel free to ask.

Jerry

Advertisements

5 thoughts on “Upgrading Project Server 2003 to Project Server 2007

  1. I was really having some problems installing project server 2007 on my machine , when I came across Jerry\’s blog while searching and I must say it was the best every guide I found to installing  project server 2007 everything was covered in great detail !! all in al great quality work ! Thanx for the help mate.

  2. Dear Usman,
     
    You are welcome.  Hopefully i will add more content that will be useful for guys like you. Have good time.
     
    Jerry

  3. Nice tutorial Jerry. I was looking for such tutorial since Microsoft Launched Microsoft Project Server 2007 as I was having a few issues.
    Its really helpfull.

  4. Dear Jerry,
    Nice tutorial, but I had small problems at migration Microsof Project Server 2007.
    My log file contains the following:
     
    **********Phase:Resource global migration start**********02/04/2008 15:25:54.977   preparing Query select UPG_PHASE_RUN_STATUS from dbo.MSP_P12UPGRADE_UPGRADE_RUN_PHASES where UPG_PHASE_UID=? AND UPG_PHASE_RUN_STATUS = ? 02/04/2008 15:25:54.977   preparing Query select PROJ_CHECKEDOUT from dbo.MSP_PROJECTS where PROJ_ID = ? 02/04/2008 15:25:54.977   Resource global is not migrated. Starting migration of Resource global02/04/2008 15:25:54.977   preparing Query exec dbo.MSP_P12UPG_INSERT_OR_UPDATE_RUN_PHASE_STATUS ?, ?, ? 02/04/2008 15:25:54.977   Executing Query insert into dbo.MSP_P12UPGRADE_PROJECT_UPGRADES (UPG_RUN_UID, UPG_PROJ_P11_ID, UPG_PROJ_UID, UPG_PROJ_P11_NAME, UPG_PROJ_STATUS, UPG_PROJ_TYPE, UPG_PROJ_START_DATE) values (?, 1, ?, ?, 3, ?, GETDATE())02/04/2008 15:25:54.977   preparing Query insert into dbo.MSP_P12UPGRADE_PROJECT_UPGRADES (UPG_RUN_UID, UPG_PROJ_P11_ID, UPG_PROJ_UID, UPG_PROJ_P11_NAME, UPG_PROJ_STATUS, UPG_PROJ_TYPE, UPG_PROJ_START_DATE) values (?, 1, ?, ?, 3, ?, GETDATE()) 02/04/2008 15:25:54.977   Adding existing Project Server 2007 resources to entity map02/04/2008 15:25:54.977   preparing Query exec dbo.MSP_P12UPG_ADD_EXISTING_P12_RESOURCES_TO_ENTITY_MAP 02/04/2008 15:25:54.977   Executing Query exec dbo.MSP_P12UPG_ADD_EXISTING_P12_RESOURCES_TO_ENTITY_MAP02/04/2008 15:25:54.993   Loading Project resglobal02/04/2008 15:25:55.133   02/04/2008 15:25:56.568   Found calendar in both global and local named Стандартный02/04/2008 15:25:56.568   Found calendar in both global and local named Standard02/04/2008 15:25:56.568   Time to execute P12UpgradeDoc::FixupCalendars(): 0 ms02/04/2008 15:25:56.584   02/04/2008 15:25:56.584   Time to execute P12UpgradeDoc::Load(): 1593 ms02/04/2008 15:25:56.584   Loading resource global failed with error 8000400502/04/2008 15:25:56.584   Executing Query update dbo.MSP_P12UPGRADE_PROJECT_UPGRADES set UPG_PROJ_STATUS = 2, UPG_PROJ_FINISH_DATE = GETDATE() where UPG_PROJ_P11_ID = 102/04/2008 15:25:56.584   preparing Query exec dbo.MSP_P12UPG_INSERT_OR_UPDATE_RUN_PHASE_STATUS ?, ?, ? 02/04/2008 15:25:56.584   Resource global migration failed with error 80004005**********Phase:Resource global migration end**********
    02/04/2008 15:25:56.584   Time to execute CUpgrader::CheckAndUpgradeResGlobal(): 1609 ms02/04/2008 15:25:56.584   Updating run table02/04/2008 15:25:56.584   preparing Query update dbo.MSP_P12UPGRADE_UPGRADE_RUNS SET UPG_RUN_STATUS = ?, UPG_RUN_FINISH_DATE = GETDATE() where UPG_RUN_UID = ? 02/04/2008 15:25:56.584   Executing Query update dbo.MSP_P12UPGRADE_UPGRADE_RUNS SET UPG_RUN_STATUS = ?, UPG_RUN_FINISH_DATE = GETDATE() where UPG_RUN_UID = ?02/04/2008 15:25:56.584   Migration finished with return code 8000400502/04/2008 15:25:56.584   Project migration failed.
    Can help me with this problem?

  5. can anyone send me jerry’s article “Upgrading Project Server 2003 to Project Server 2007”. there is problem in downloading it.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s