none
Project Server 2013 Test to Production Migration RRS feed

  • Question

  • Hi All,

    We have a test environment of Project Server 2013 where  project server and SQL server installed  in a single server.  The production server is configured with two servers i.e. the application and SQL server installed in separate server. What is the best practice to move the data and configuration from test server to production server.


    Thanks in advance, Taj

    Wednesday, February 10, 2016 12:21 PM

Answers

  • Hello taj2014,

    I agree with Gary here. Project Server is completely rely on SharePoint Platform which a Basically a Site Collection Provisioned within a Web Application and you can accomplish this task using DB attach Method.

    In order to Migrate your Development environment to Production, Below are the basic steps.

    1. Make Sure your Target (Prod) Farm is having the Similar Versions and patch level of SharePoint and project Server

    2. Create a New Web application in Target Farm accordingly

    3. Backup your Content Database (of Project Web app) from Development Environment (e.g.- WSS_Project_Content) using SQL management Studio

    4. Restore the Database to the Target Database Server (Production)

    5. Open Central administration of the Target Farm (Prod) and direct to Content Databases of the Web Application

    6. Select the Web Application that you created newly.

    7. Remove the Default Database created when you were Creating the New Web Application.

    8. Point the New Database there (or use Mount-SPContentDatabase command in Powershell)

    Yet, above steps may vary up on your structure. such as how you have created the Project Web App (If its resides as a site collection of a common web application which has other applications too, you need to backup only that particular site collection or Database)

    for further details have a look at these articles describes it well -

    Steps - https://pwmather.wordpress.com/2013/05/02/projectserver-2013-environment-migration-rollover-steps-powershell-ps2013-msproject-sp2013/

    TechNet Ref - https://technet.microsoft.com/en-us/library/dd857479%28v=office.12%29.aspx?f=255&MSPPError=-2147217396

    Hope this helps.

    ------------------------------------------------------------------

    Please do not forget to mark this as answer if it was helpful

    • Marked as answer by arun_2014 Wednesday, February 17, 2016 1:38 PM
    Thursday, February 11, 2016 1:54 AM

All replies

  • The way all SharePoint and Project Server migrations are accomplished is generally through DB Attach. You can find ample information on this on TechNet. Essentially, you provision a site attaching to the existing databases, which you restore to the new environment from SQL backups.

    Gary Chefetz, MCITP, MCP, MVP msProjectExperts
    Project and Project ServerFAQs
    Project Server Help BLOG

    Wednesday, February 10, 2016 10:05 PM
    Moderator
  • Hello taj2014,

    I agree with Gary here. Project Server is completely rely on SharePoint Platform which a Basically a Site Collection Provisioned within a Web Application and you can accomplish this task using DB attach Method.

    In order to Migrate your Development environment to Production, Below are the basic steps.

    1. Make Sure your Target (Prod) Farm is having the Similar Versions and patch level of SharePoint and project Server

    2. Create a New Web application in Target Farm accordingly

    3. Backup your Content Database (of Project Web app) from Development Environment (e.g.- WSS_Project_Content) using SQL management Studio

    4. Restore the Database to the Target Database Server (Production)

    5. Open Central administration of the Target Farm (Prod) and direct to Content Databases of the Web Application

    6. Select the Web Application that you created newly.

    7. Remove the Default Database created when you were Creating the New Web Application.

    8. Point the New Database there (or use Mount-SPContentDatabase command in Powershell)

    Yet, above steps may vary up on your structure. such as how you have created the Project Web App (If its resides as a site collection of a common web application which has other applications too, you need to backup only that particular site collection or Database)

    for further details have a look at these articles describes it well -

    Steps - https://pwmather.wordpress.com/2013/05/02/projectserver-2013-environment-migration-rollover-steps-powershell-ps2013-msproject-sp2013/

    TechNet Ref - https://technet.microsoft.com/en-us/library/dd857479%28v=office.12%29.aspx?f=255&MSPPError=-2147217396

    Hope this helps.

    ------------------------------------------------------------------

    Please do not forget to mark this as answer if it was helpful

    • Marked as answer by arun_2014 Wednesday, February 17, 2016 1:38 PM
    Thursday, February 11, 2016 1:54 AM