none
Project Server 2010- M RRS feed

  • Question

  • Hi,

    I need Project Server migration steps,

    i.e. 1. Checklist

          2. Prerequisite

          3. Issues/Risks happens during migration

     Versions:

    2007 to 2007(from one server to other server)

    2010 to 2010(from one server to other server)

    2007 to 2010

    Please help


    K.Gokulraj

    Wednesday, April 30, 2014 6:57 AM

All replies

  • HI

    For Project Server 2007 (from one server to other server)

    If you cannot use the same site collection in Project Server 2007 when you migrate to new environment.

    You can restore and use the (Publish, Draft, Archive & Reporting) database to new environment and then provision the PWA using the new site collection.

    The export and import the workspaces from old environment to new environment under the new PWA site collection and use the relinker tool to link the workspaces with project.

    You can download the relink tool in the below location

    http://technet.microsoft.com/en-us/library/cc197498(v=office.12).aspx

    For Project Server 2010 (from one server to other server)

    In Project Server 2010 you can use the same PWA site collection. You can backup and restore content and project databases (Publish, Draft, Archive & Reporting) in new environment and then provision the PWA using the same site collection.

    Project Server 2007 to 2010 migration

    Pre-upgrade steps

    1] The Project Server 2007 environment must be at SP2 or higher.

    2] All the Projects must be saved and published since the installation of SP2. Below is the query to check the projects which are not saved and published.

    select Distinct PROJ_NAME AS 'List of Projects Not Saved and Published Since the Installation of Service Pack2'

    ,PROJ_PROP_AUTHOR, PROJ_LAST_SAVED, WPROJ_LAST_PUB

    from dbo.MSP_PROJECTS

    where PROJ_TYPE = 0

    and ((dbo.MSP_PROJECTS.PROJ_LAST_SAVED < (SELECT MAX(TimeStamp) FROM dbo.Versions))

    OR (dbo.MSP_PROJECTS.WPROJ_LAST_PUB < (SELECT MAX(TimeStamp) FROM dbo.Versions)))

    GROUP BY PROJ_NAME,PROJ_PROP_AUTHOR, PROJ_LAST_SAVED, WPROJ_LAST_PUB

    Order by PROJ_NAME

    go

    3] Check if there are any Lookup tables using reserved names in Project Server 2010

    USE <ProjectServer_Published>

    select LT_NAME

    AS 'List of Lookup Table names with Reserved Names. These names must be changed before proceeding with the Upgrade'

    from dbo.MSP_LOOKUP_TABLES

    WHERE LT_NAME IN

    ('Department',

    'Project Impact',

    'Relative Importance',

    'Sample Areas Impacted',

    'Sample Primary Objective')

    -- Cost Type, Health, RBS and State are standard in 2007

    go

    4] Check if there are any names present in Project Server 2007 which is reserved in Project Server 2010.

    USE <ProjectServer_Published>

    select MD_PROP_NAME

    AS 'List of Custom Fields names with Reserved Names. These names must be changed before proceeding with the Upgrade'

    from dbo.MSP_CUSTOM_FIELDS

    WHERE MD_PROP_NAME IN

    ('Flag Status',

    'Project Departments',

    'Project Impact',

    'Relative Importance',

    'Resource Departments',

    'Sample Approved Finish Date',

    'Sample Approved Start Date',

    'Sample Areas Impacted',

    'Sample Assumptions',

    'Sample Business Need',

    'Sample Compliance Proposal',

    'Sample Goals',

    'Sample Post Implementation Review Date',

    'Sample Post Implementation Review Notes',

    'Sample Primary Objectives',

    'Sample Proposal Cost',

    'Sample Proposed Finish Date',

    'Sample Proposed Start Date')

    go

    The above queries can be found in the below article.

    http://technet.microsoft.com/en-us/library/gg595640.aspx

    Migrating from Project Server 2007 to Project Server 2010

    1] Take the backup of Content, Draft, Archive, Publish & Reporting databases from Project Server 2007 environment and restore it to Project Server 2010 environment.

    2] Attach the content database to a web-application.

    3] Create Project Server Service Application.

    4] Provision the PWA using the restored Project databases and site collection Present in the restored content database. In this step the Project database upgrade will happen.

    Below article contains the detailed steps to migrate from Project Server 2007 to Project Server 2010.

    http://technet.microsoft.com/en-us/library/ee662500(v=office.14).aspx

    Thursday, May 1, 2014 2:53 PM