none
Moving Project Server 2010 database to SQL Server 2012 Enterprise Edition SP1 CU7 RRS feed

  • Question

  • Hi all,

    We have Project Server 2010 + SQL Server 2008 R2, but we need to upgrade DB to SQL Server 2012 Enterprise Edition SP1 CU7.  Are there any recommendations for the migrating?

    Tuesday, February 4, 2014 5:24 AM

Answers

  • Hello,

    Providing your Project Server 2010 farm is at least SP1 it will be fine. High-level steps are below:

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

    Basically shut down the servers in the farm, copy all of your farm DBs to the new SQL server, ensure all the logins are present on the new SQL server, script out the delete expired sessions job and restore that to the new SQL server, re-point / create DNS Alias so that the Project Server farm is using the same name for the SQL server. Start up the Project Server / SharePoint servers. Install the 2008 Native Client on the new SQL 2012 server (if SQL AS is running there there), then build the cube.

    I would test this on a non production farm first.

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com | CPS

    • Marked as answer by Denis F Tuesday, February 4, 2014 9:56 AM
    Tuesday, February 4, 2014 7:04 AM
    Moderator

All replies

  • Hello,

    Providing your Project Server 2010 farm is at least SP1 it will be fine. High-level steps are below:

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

    Basically shut down the servers in the farm, copy all of your farm DBs to the new SQL server, ensure all the logins are present on the new SQL server, script out the delete expired sessions job and restore that to the new SQL server, re-point / create DNS Alias so that the Project Server farm is using the same name for the SQL server. Start up the Project Server / SharePoint servers. Install the 2008 Native Client on the new SQL 2012 server (if SQL AS is running there there), then build the cube.

    I would test this on a non production farm first.

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com | CPS

    • Marked as answer by Denis F Tuesday, February 4, 2014 9:56 AM
    Tuesday, February 4, 2014 7:04 AM
    Moderator
  • Thank's Paul, i'll check it.
    Tuesday, February 4, 2014 9:57 AM
  • Paul, one more question then. Is it ok if we rename Project Server DB server , for example from DBSER05 to DBSRVCL07\APPDB ?
    Tuesday, February 4, 2014 10:44 AM