Project Server 2013-Migrating data different Domain

This articles provides step by step instructions for Successful deployment of EPM data from Development to Production.

1. Backup Source DB:
Take Backup of Development Server Databases (PWA Database, Web Application Content Database).

Open SQL Server Management Studio (from Development Server):
– ProjectWebApp (Project Server DB)
– WSS_Content_PS (Web Application Content DB)

Right click on the source databases, and select Tasks – Backup

2. Dismount DB:
Dismount Production Server Databases (ProjectWebApp, WSS_Content_PS) using below Powershell Command:

Dismount-SPProjectWebInstance -SiteCollection http://ServerName/PWA

Dismount-SPContentDatabase WSS_Content_PS

3. Delete Existing DB:
Delete existing Database (ProjectWebApp, WSS_Content_PS) – with Close existing connections options.

4. Restore Backup DB:
Restore the Backup Databases using — Open SQL Server Management Studio in the target environment, right click on the Databases heading, and choose the option to restore the database.

5. Mount DB:
Mount Databases using Powershell command:

Mount-SPContentDatabase WSS_Content_PS -DatabaseServer DBName\InstanceName -WebApplication http://ServerName

Mount-SPProjectDatabase -Name ProjectWebApp -WebApplication http://ServerName -DatabaseServer DBNam\InstanceName

Mount-SPProjectWebInstance -DatabaseName ProjectWebApp -SiteCollection http://ServerName/PWA -DatabaseServer DBName\InstanceName

Mounting of Database can be verified using the below command:
Get-SPProjectWebInstance -URL http://ServerName/PWA | Select ProvisioningStatus

6. Verify:
After Mounting, Login in to PWA site and when below error occurs:
Sorry, this site hasn’t been shared with you.

Admin has to be given Admin rights thru PowerShell command using:

Grant-SPProjectAdministratorAccess -Url http://ServerName/PWA -UserAccount Domain\AdminAccount

7. Deploy Solution file:
WSP files are deployed using the below command:

Uninstall-SPSolution -Identity “SolutionFile.wsp” -WebApplication “http://ServerName/”
Remove-SPSolution -Identity “SolutionFilewsp”

Add-SPSolution “E:\PATH\SolutionFile.wsp”
Install-SPSolution -Identity “SolutionFile.wsp” -WebApplication “http://ServerName/” -GACDeployment

Get-SPFeature -Site “http://ServerName/PWA” | Sort DisplayName | FT DisplayName,Id

Happy Deployment!!!