Project Server 2013 migration between environments.

Project Server Migration required 2 databases ( PWA database + web application DB)




Step 1 :  Dismounting Project web instance.


Dismount-SPProjectWebInstance -SiteCollection  <URL of Test / Dev PWA site that you want to refresh with the Production data and config>









Step2 :


 Dismount-SPContentDatabase “<Database name here>”




Step3 : Mounting Production Content DB 


Mount-SPContentDatabase “<content database name restored in previous step>” -DatabaseServer “<Test / DEV SQL Server>” –WebApplication <web application URL>




Step4 :  Mounting Project Database




Mount-SPProjectDatabase -Name “Name of the restored Project Web App database to mount” –WebApplication “Web Application ULR that the Project Web App database will mount to” –DatabaseServer “Test / Dev SQL Server where the database was restored”




Step5  : Mounting Project database to web instance.


Mount-SPProjectWebInstance –DatabaseName “Name of the restored Project Web App database to mount” –SiteCollection “web application URL + PWA path” –DatabaseServer “Test / Dev SQL Server where the database was restored”




NOTE : For example if the instance is called /PWA in Production, use /PWA in the command below on the Test / Dev environment.




Verification :


Get-SPProjectWebInstance –URL <PWA URL> | Select ProvisioningStatus




Source of article is : http://pwmather.wordpress.com/2013/05/02/projectserver-2013-environment-migration-rollover-steps-powershell-ps2013-msproject-sp2013/


Other Links :


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