Export (0) Print
Expand All

Upgrade your databases and Project Web App site collections (Project Server 2013)

Project Server 2013
 

Applies to: Project Web App, Project Server 2013

Topic Last Modified: 2013-12-18

Summary:How to upgrade your required Project Server 2010 databases and your Project Web App site collection to Project Server 2013.

This article is one is a series of articles for upgrade to Project Server 2013. We recommend that you read the following articles before you try any procedures in this article:

After restoring your Project Server 2010 databases and the SharePoint content database that contains your Project Web App site data, you can then run the steps necessary to upgrade the data and the Project Web App site collection to Project Server 2013. The actual upgrade process can be divided into two separate phases:

  • SharePoint upgrade phase:

    • Check the SharePoint content database that contains your Project Site data for errors that can cause upgrade to fail.

    • Attach and upgrade the SharePoint content database.

    • Take ownership of the site collection you want to upgrade.

    • Migrate users from Windows Classic authentication to claims-based authentication (optional).

    • Check the SharePoint site for issues that can cause upgrade to fail.

    • Upgrade the SharePoint Site.

  • Project Server upgrade phase:

    • Consolidate your Project Server 2010 databases to a Project Web App database.

    • Attach your Project Web App database to the web application.

    • Upgrade your Project Web App database.

    • Mount your Project Web App Instance.

    • Upgrade your Project Web App Instance.

    • Enable the PWA feature.

 

Steps Required Windows PowerShell cmdlet

1

Check the SharePoint content database that contains your Project Site data for errors that can cause upgrade to fail.

Test-SPContentDatabase

2

Attach and upgrade the SharePoint content database.

Mount-SPContentDatabase

3

Take ownership of the site collection you want to upgrade.

Set-SPSite

4

Migrate users from Windows Classic authentication to claims-based authentication (optional).

NoteNote:
This step is only required if your Project Server 2010 web application is using Classic Windows authentication, and your Project Server 2013 web application is using claims-based authentication.

(Get-SPWebApplication <SPWebAppPipeBind>).MigrateUsers($true)

5

Check the SharePoint site collection for issues that can cause upgrade to fail.

Test-SPSite

6

Upgrade the SharePoint site.

Upgrade-SPSiteUpgrade-SPSite

Run the Test-SPContentDatabase cmdlet to check the SharePoint Server 2010 content database prior to running the Mount-SPContentDatabase cmdlet to connect the SharePoint 2010 database to the farm. The Test-SPContentDatabase cmdlet is a non-destructive test operation that checks the database and post errors that prevent upgrade of the database.

Test-SPContentDatabase -Name <contentdbName> -WebApplication <URL> 
-ServerInstance <servername>

For example:

Test-SPContentDatabase -Name PWA_ContentDB -WebApplication http://Contoso:80  -ServerInstance SQLServer1

 

Required parameters

–Name

Specifies the existing content database to test.

The type must be a valid name of a SharePoint content database (for example, SPContentDB1).

–WebApplication

Specifies the SharePoint Web application to use to test the content database.

The type must be a valid GUID, in the form 12345678-90ab-cdef-1234-567890bcdefgh; or a valid name of SharePoint web application (for example, MyOfficeApp1); or an instance of a valid SPWebApplication object.

-ServerInstance

Specifies the instance of the database service to use to test the specified content database.

The type must be a valid GUID, such as 12345678-90ab-cdef-1234-567890bcdefgh; a valid name of a SQL Server instance (for example, DBSvrInstance1); or an instance of a valid SPDatabaseServiceInstance object.

Running the Test–SPContentDatabase cmdlet checks the SharePoint Server 2010 content database and posts any possible errors in the data. It provides a description of the error, possible remedy, and an UpgradeBlocking flag to note if the error will prevent an upgrade of the database. It is important to address any errors in which the UpgradeBlocking flag is set to a value of True.

Run the Mount-SPContentDatabase Windows PowerShell cmdlet to connect the SharePoint Server 2010 database to the specified Web Application and also upgrade the database. Ensure that the account that you use to attach the databases is a member of the db_owner fixed database role for the content databases that you want to upgrade.

NoteNote:
Using the SharePoint Central Administration pages to attach a content database is not supported for upgrading.
Mount-SPContentDatabase -Name <contentdbName> -WebApplication <URL> -DatabaseServer <servername> -NoB2BSiteUpgrade

For example:

Mount-SPContentDatabase -Name PWA_ContentDB -WebApplication http://Contoso:80 -DatabaseServer SQLServer1 -NoB2BSiteUpgrade

 

Required parameters

–Name

Specifies the existing content database that you want to connect and upgrade.

The type must be a valid name of a SharePoint content database (for example, SPContentDB1).

–WebApplication

Specifies the SharePoint web application to which you want to connect the content database.

The type must be a valid GUID, in the form 12345678-90ab-cdef-1234-567890bcdefgh; or a valid name of SharePoint web application (for example, MyOfficeApp1); or an instance of a valid SPWebApplication object.

-DatabaseServer

Specifies the instance of the database service to use to connect the specified content database.

The type must be a valid GUID, such as 12345678-90ab-cdef-1234-567890bcdefgh; a valid name of a SQL Server instance (for example, DBSvrInstance1); or an instance of a valid SPDatabaseServiceInstance object.

-NoB2BSiteUpgrade

This flag specifies that you are upgrading a SharePoint Server 2010 content database (version to version).

You must add yourself as an owner of the PWA site collection. This is required for the proceeding steps in which you have to verify and then upgrade the site collection.

Set-SPSite  -Identity <sitecollectionName> -SecondaryOwnerAlias <account>

For example:

Set-SPSite -Identity http://contoso/pwa -SecondaryOwnerAlias "contoso\FarmAdmin"

 

Required Parameters

–Identity

Specifies the site collection that you want to be added to as an owner.

–SecondaryOwnerAlias

Allows you to specify your account as a secondary owner of the site collection.

If you are migrating Project Server 2010 users who were using Windows Classic authentication over to claims-based authentication when upgrading to Project Server 2013, you will need to run the following Windows PowerShell cmdlet. If this is not done, your users will not be able to log on to Project Web App after upgrade.

(Get-SPWebApplication <webappURL>).migrateUsers($true)

For example:

(Get-SPWebApplication http://contoso:80).migrateUsers($true)

For more information about this method, see SPWebApplication.MigrateUsers Method.

The Project Web App site does not support SharePoint Server 2010 version mode. The site collection for PWA must be upgraded in order to work in Project Server 2013. It is important to note that this requirements in only for PWA, and that core SharePoint site collections do not require this.

Prior to upgrading the site collection, we recommend that you run the Test-SPSite cmdlet to verify if the site collection has any issues that can cause upgrade of the site collection to fail. You can review the results and fix any upgrade blocking issues.

Test-SPSite -Identity <URL>

For example:

Test-SPSite -Identity http://contoso/pwa

 

Required Parameters

-Identity

Specifies the URL for the site collection that you want to check.

The results display the number of "FailedWarningCounts" that it discovered through the test, but will not display information about the failure. To find more information about the failure, you can navigate to the PWA Site Settings page and run a health check on the site collection by doing the following:

To run a health check on the PWA site collection to view upgrade warning information
  1. In a browser window, enter the URL for the site (for example, http://contoso/pwa). At the end of the URL, type the following: /_layouts/15/settings.aspx. In this example, the complete URL would be http://contoso/pwa/_layouts/15/settings.aspx. This gives you a direct link to the Site Setting page. You cannot display the PWA site page because it has not been upgraded and is still in SharePoint Server 2010 mode.

  2. On the PWA Site Settings page, in the Site Collection Administration section, click Site Collection Health Checks.

    NoteNote:
    Notice that a message displays at the top of the page stating that the page is in SharePoint 2010 mode, because the site collection has not been upgraded yet.
  3. On the Run Site Collection Health Checks page, click Run checks to start a health check on the site collection.

The results of the health check will display verbose information about any warnings that were found by the Test-SPSite cmdlet. For example, it will tell you if any pages may have been customized and may cause unexpected behavior after upgrade. It will provide the page URL and an option to reset the page to default.

CautionCaution:
Before using the option to reset the page to default, make sure that you track the customization that were implemented on the page so that you can manually re-create them after upgrade. Resetting the page to default will return the page to the default template, and will remove your customizations that were implemented on the page.

After checking the PWA site collection and correcting any issues that can cause upgrade to fail, you can run the Upgrade-SPSite Windows PowerShell cmdlet to upgrade the PWA site to SharePoint 2013.

Upgrade-SPSite -Identity <URL> -versionupgrade

For example

Upgrade-SPSite -Identity http://contoso/pwa -versionupgrade

 

Required parameters

–Identity

Specifies the URL for the site collection.

–versionupgrade

This flag specifies that you are upgrading the site from SharePoint Server 2010 to Project Server 2013.

After you complete the SharePoint Upgrade phase, you will be able to connect to the PWA site, but will be unable to view any project data because the Project Server 2010 database have not been connected and upgraded yet. Use the following steps in the Project Server upgrade phase to complete the upgrade.

 

Steps Required Windows PowerShell cmdlet

1

Consolidate your Project Server 2010 databases to a Project Project Web App database

Convertto-SPProjectDatabase

2

Attach your Project Web App database to the web application.

Mount-SPProjectDatabase

3

Check your Project Web App database for errors

Test-SPProjectDatabase

4

Upgrade your Project Web App database

Upgrade-SPProjectDatabase

5

Mount your Project Web App Instance

Mount-SPProjectWebInstance

6

Check your Project Web App instance for errors

Test-SPProjectWebInstance

7

Upgrade your Project Web App Instance

Upgrade-SPProjectWebInstance

8

Enable PWA features

Enable-SPfeature

Run the Convertto-SPProjectDatabase Windows PowerShell cmdlet to consolidate your restored Project Server 2010 databases to a single Project Server 2013 Project Web App database. This cmdlet also connects the new Project Server 2013 Project Web App database to the Project Server 2013 web application.

Convertto-SPProjectDatabase -WebApplication <URL> -Dbserver <databaseServerName> -ArchiveDbname<ArchivedbName> -DraftDbname<DraftdbName> -PublishedDbname<PublisheddbName> -ReportingDbname<ReportingdbName> -ProjectServiceDbname<ProjectWebAppdbName> 

For example:

Convertto-SPProjectDatabase -WebApplication http://contoso:80 -Dbserver SQLServer1 -ArchiveDbname ContosoProjectArchived -DraftDbname ContosoProjectDraft -PublishedDbname ContosoProjectPublished -ReportingDbname ContosoProjectReporting -ProjectServiceDbname ContosoProjectWebApp1 

 

Required Parameters

–WebApplication

Specifies the SharePoint web application that you created for the Project Service Application.

The type must be a valid GUID, in the form 12345678-90ab-cdef-1234-567890bcdefgh; or a valid name of SharePoint web application (for example, MyOfficeApp1); or an instance of a valid SPWebApplication object.

-Dbserver

Specifies the instance of the database service on which the databases are located.

The type must be a valid GUID, such as 12345678-90ab-cdef-1234-567890bcdefgh; a valid name of a SQL Server instance (for example, DBSvrInstance1); or an instance of a valid SPDatabaseServiceInstance object.

-ArchiveDbname

The name of the Project Server 2010 Archived database that you restored on SQL Server.

-DraftDbname

The name of the Project Server 2010 Draft database that you restored on SQL Server.

-PublishedDbname

The name of the Project Server 2010 Published database that you restored on SQL Server.

-ReportingDbname

The name of the Project Server 2010 Reporting database that you restored on SQL Server.

-ProjectServiceDbname

The name that you want to call the Project Server 2013 Project Web App database.

When you run the cmdlet, you are prompted for a confirmation that you want to continue. Type Y to continue.

After running this cmdlet successfully, you will see a confirmation message of "Conversion of Project Databases complete." You will also see the new Project Web App database on the computer that is running SQL Server.

Run the Mount-SPProjectDatabase Windows PowerShell cmdlet to attach your new Project Web App database to the web application that you had created earlier in your Project Server 2013 environment.

Mount-SPProjectDatabase -Name <ProjectWebAppdbName> -WebApplication<URL> -DatabaseServer <databaseServerName>

For example:

Mount-SPProjectDatabase -Name ContosoProjectWebApp1 -WebApplication http://contoso:80 -DatabaseServer SQLServer1

 

Required parameters

-Name

Specifies the name of your Project Web App database.

–WebApplication

Specifies the SharePoint web application that you created for the Project Service Application.

The type must be a valid GUID, in the form 12345678-90ab-cdef-1234-567890bcdefgh; or a valid name of SharePoint web application (for example, MyOfficeApp1); or an instance of a valid SPWebApplication object.

-DatabaseServer

Specifies the instance of the database service on which the Project Web App database is located.

The type must be a valid GUID, such as 12345678-90ab-cdef-1234-567890bcdefgh; a valid name of a SQL Server instance (for example, DBSvrInstance1); or an instance of a valid SPDatabaseServiceInstance object.

When the Mount-SPProjectDatabase cmdlet is finished, it will return you to the Windows PowerShell command prompt. Currently, you will not see a confirmation message upon successful completion.

Run the Test-SPProjectDatabase cmdlet to check your Project Web App database for issues that can cause upgrade of this database to fail. The Test-SPProjectDatabase cmdlet is a non-destructive test operation that will check the database and will post error that will prevent upgrade of the database.

Test-SPProjectDatabase -Name <contentdbName> -WebInstance <URL> -DatabaseServer<servername>

For example:

Test-SPProjectDatabase -Name ContosoProjectWebApp1 -WebInstance http://contoso:80 -DatabaseServer SQLServer1

 

–Name

Specifies the name of your Project Web App database.

–WebInstance

Specifies the SharePoint web application that the Project Web App database is associated with.

-Databaseserver

Specifies the instance of the database service on which the Project Web App database is located.

The type must be a valid GUID, such as 12345678-90ab-cdef-1234-567890bcdefgh; a valid name of a SQL Server instance (for example, DBSvrInstance1); or an instance of a valid SPDatabaseServiceInstance object.

Running the Test–SPProjectDatabase cmdlet will check your Project Web App database and will post any possible errors in the data. It provides a description of the error, possible remedy, and an UpgradeBlocking flag to note if the error will prevent an upgrade of the database. It is important to address any errors in which the UpgradeBlocking flag is set to a value of True.

Run the Upgrade-SPProjectDatabase Windows PowerShell cmdlet to upgrade your new Project Web App database to Project Server 2013. The four Project Server 2010 databases were merged to the Project Web App database by the Convertto-SPProjectDatabase in step 1.

Upgrade-SPProjectDatabase -Name <ProjectWebAppdbName> -WebApplication <URL> -DatabaseServer <databaseServerName>

For example:

Upgrade-SPProjectDatabase -Name ContosoProjectWebApp1 -WebApplication http://contoso:80 -DatabaseServer SQLServer1

 

Required Parameters

-Name

Specifies the name of your Project Web App database.

–WebApplication

Specifies the SharePoint web application you created for the Project Service Application.

The type must be a valid GUID, in the form 12345678-90ab-cdef-1234-567890bcdefgh; or a valid name of SharePoint web application (for example, MyOfficeApp1); or an instance of a valid SPWebApplication object.

-DatabaseServer

The type must be a valid GUID, such as 12345678-90ab-cdef-1234-567890bcdefgh; a valid name of a SQL Server instance (for example, DBSvrInstance1); or an instance of a valid SPDatabaseServiceInstance object.

When you run the cmdlet, you are prompted for a confirmation that you want to continue. Type Y to continue.

When the Upgrade-SPProjectDatabase cmdlet is finished, it will return you to the Windows PowerShell command prompt. Currently, you will not see a confirmation message upon successful completion.

Run the Mount-SPProjectWebInstance Windows PowerShell cmdlet to connect your new Project Web App database to a Project Web App instance in Project Server 2013.

Mount-SPProjectWebInstance -DatabaseName <ProjectWebAppdbName> -SiteCollection<URL> -DatabaseServer <databaseServerName>

For example:

Mount-SPProjectWebInstance -DatabaseName ContosoProjectWebApp1 -SiteCollection http://contoso/pwa -DatabaseServer SQLServer1 

 

Required parameters

-DatabaseName

Specifies the name of your Project Web App database.

–SiteCollection

Specifies the site collection you created for the Project Service Application.

-DatabaseServer

Specifies the instance of the database service on which the Project Web App database is located.

The type must be a valid GUID, such as 12345678-90ab-cdef-1234-567890bcdefgh; a valid name of a SQL Server instance (for example, DBSvrInstance1); or an instance of a valid SPDatabaseServiceInstance object.

When you run the cmdlet, you are prompted for a confirmation that you want to continue. Type Y to continue.

Prior to trying to upgrade the Project Web App instance, run the Test-SPProjectWebInstance Windows PowerShell cmdlet to check the Project Web App instance for issues that can cause upgrade to fail.

This cmdlet checks for issues such as if the Project Business Intelligence (BI) Center exists for all project sites, or if there are unprocessed jobs in the queue and also queue status, and for issues with project workspaces. The result of the test appears in Windows PowerShell, but the information is more readable if you export the results to a text file. Use the results to address any issues with a "FailedWarning" status.

Test-SPProjectWebInstance -Identity <URL or Site ID>

For example:

Test-SPProjectWebInstance -Identity http://contoso/pwa

 

Required parameters

-Identity

Specifies the URL of the Project Web App instance.

Run the Upgrade-SPProjectWebInstance Windows PowerShell cmdlet to upgrade the Project Web App instance to Project Server 2013.

This cmdlet checks for issues such as if the Project Business Intelligence (BI) Center exists for all project sites, or if there are unprocessed jobs in the queue and also queue status, and for issues with project workspaces. The results of the test will display in Windows PowerShell, but the information will be more readable if you export the results to a text file. Use the results to address any issues with a "FailedWarning" status.

Upgrade-SPProjectWebInstance -Identity <URL or site ID>

For example:

Upgrade-SPProjectWebInstance -Identity http://contoso/pwa

 

Required parameter

-Identity

Specifies the URL of the Project Web App instance.

When you run the cmdlet, you are prompted for a confirmation that you want to continue. Type Y to continue.

After you run this cmdlet successfully, you see a confirmation message of "Upgrade of single project site completed."

Run the Enable-SPFeature Windows PowerShell cmdlet to enable the PWA site feature on the site collection.

Enable-SPFeature -Identity pwasite -URL <ProjectSiteCollection>

For example:

Enable-SPFeature -Identity pwasite -URL http://contoso/PWA

 

Required parameter

-Identity

-URL

Specifies the URL of the Project Web App site collection.

When the Enable-SPFeature cmdlet finishes, it returns you to the Windows PowerShell command prompt. Currently, you will not see a confirmation message upon successful completion.

Open your Project Web App site URL to view your upgraded site and data.

If you have additional questions, try the Project forums. The Project forums give you the chance to have your question discussed by other participants, Project MVPs, and Project community experts.

If you would like to provide feedback on this article, choose the Yes or No option for Did you find this article helpful? located at the end of this page, and then type your feedback in the box that appears.  

This feedback tool appears at the end of each Project Server library article on TechNet.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft