1. No category

Project Server and SharePoint Server
Installation
Requirement
Will coexist on the
same farm with
Will NOT work with
Project Server 2013
SharePoint Server 2013
Enterprise
SharePoint Server 2013
Enterprise
SharePoint Foundation 2010
Project Server 2010
SharePoint Server 2010
Enterprise
SharePoint Server 2010
Enterprise
Office SharePoint Server
2007
Project Desktop and Project Server
Project Server
2007
Project Server 2010
Project Server 2013 &
Project Online
Project Professional 2013,
Project Pro for Office 365
Not Supported
Not Supported
Full connectivity
Project Professional 2010
Not Supported
Full connectivity
Not Supported
Full connectivity
Connectivity to Server in
BCM*
Not Supported
Project Professional 2007
(Project Professional 2007 SP2 required)
Self hosting
on-premise
(as a Service)
Data
Data
You manage
Applications
You manage
(as a Service)
Applications
Applications
Data
Middleware
Middleware
O/S
O/S
O/S
Virtualization
Virtualization
Servers
Servers
Storage
Storage
Networking
Networking
Middleware
Virtualization
Servers
Storage
Networking
Managed by vendor
Runtime
Managed by vendor
Runtime
Runtime
You manage
Software
Infrastructure
Auto HA, Fault-Tolerance
Friction-free scale
Self-provisioning,
management at scale
Office 365 (SaaS)
Value Prop:
Value Prop:
Full h/w control – size/scale
Roll-your-own HA/DR/scale
Project Server (On-premise)
100% of API surface area
Easy migration of existing apps
Roll-your-own HA/DR/scale
Project Server (IaaS)
Hosted Project Server
Project Server
Control
Project Online
Cost-efficiency
Value Prop:
Event
Receiver
SharePoint
Project
Azure
Workflow
Migrating to
Project Online
link
Migrating to Project
Server 2013
Link to VME
Draft (draft.*)
Publish (pub.*)
Reporting (dbo.*)
Archive (ver.*)
Migration Plan
Plan Upgrade
Setup New Project
2013 Farm
Upgrade to Project
Server 2010
Preparing Project
Server 2010
Backup and Restore
Content and Project
DBs
SharePoint Mount and
Upgrade Sites
•
Test
•
Post Migration
Enable PWA Feature
Mount and Upgrade
Project Web Instance
Upgrade and Mount
Project DB
Convert Project DB
Learn
• Upgrade methods
• New capabilities
• Downtime mitigation
Validate
•
•
•
•
Prepare
Troubleshooting
Upgrade event failures
UI/UX issues
Data issues
•
•
•
•
Implement
•
•
•
•
Build/upgrade farms
Deploy customizations
Minimize downtime
Monitor progress
Document environment
Manage customizations
Plan upgrade strategy
Make items upgradable
Test
•
•
•
•
Build test farms
Use real data
Evaluate techniques
Find issues early
PC318 - Project Server 2013
Deployment Best Practices
from the field
Plan Upgrade
Setup New Project
2013 Farm
Upgrade to Project
Server 2010
Preparing Project
Server 2010
Backup and Restore
Content and Project
DBs
• Plan for
•Clients
•Upgrading
customizations
•Multiple test cycles
Test
•
SharePoint Mount and
Upgrade Sites
•
Post Migration
Enable PWA Feature
Mount and Upgrade
Project Web Instance
Upgrade and Mount
Project DB
Convert Project DB
Performance
Multiple
servers for
most server
roles
Multiple servers
for each server
role, may include
multiple farms
for specific
purposes.
Each server
role on its own
server
Bare Metal vs VM
Availability
Migrating to Project Server 2013
Exchange
Server 2013
(Optional)
IE8 or latest
version of
Firefox, Chrome
or Safari
Project
Professional
Windows 7 or 8
TechNet
Lync 2010
(Optional)
Hardware and software requirements for Project Server 2013
Plan Upgrade
•
Setup New Project
2013 Farm
• Plan for
•Clients
•Upgrading
customizations
•Multiple test cycles
• Review Hardware
requirements
• Plan new farm
topology
• SharePoint 2013 +
Project Server 2013
running
Test
Post Migration
Upgrade to Project
Server 2010
Preparing Project
Server 2010
Backup and Restore
Content and Project
DBs
SharePoint Mount and
Upgrade Sites
•
Enable PWA Feature
Mount and Upgrade
Project Web Instance
Upgrade and Mount
Project DB
Convert Project DB
No direct path from
2003 or 2007 to
2013
Create migration
Farms to migrate
data
Will require more
downtime
Plan Upgrade
•
Setup New Project
2013 Farm
Upgrade to Project
Server 2010
• Plan for
•Clients
•Upgrading
customizations
•Multiple test cycles
• Review Hardware
requirements
• Plan new farm
topology
• SharePoint 2013 +
Project Server 2013
running
• Follow established
upgrade path from
previous versions of
Project
Test
Post Migration
Enable PWA Feature
Preparing Project
Server 2010
Backup and Restore
Content and Project
DBs
SharePoint Mount and
Upgrade Sites
•
Mount and Upgrade
Project Web Instance
Upgrade and Mount
Project DB
Convert Project DB
Use XXXXX_Published
Select RES_NAME, WRES_ACCOUNT, WRES_EMAIL
From MSP_RESOURCES
Where RES_PREVENT_ADSYNC = 1
Plan Upgrade
•
Setup New Project
2013 Farm
Upgrade to Project
Server 2010
Preparing Project
Server 2010
• Plan for
•Clients
•Upgrading
customizations
•Multiple test cycles
• Review Hardware
requirements
• Plan new farm
topology
• SharePoint 2013 +
Project Server 2013
running
• Follow established
upgrade path from
previous versions of
Project
• Enable User AD
sync
• Check DB
Consistency and
ownership
• Disable BCM
Test
Post Migration
Enable PWA Feature
Mount and Upgrade
Project Web Instance
Backup and Restore
Content and Project
DBs
SharePoint Mount and
Upgrade Sites
•
Upgrade and Mount
Project DB
Convert Project DB
stsadm -o setsitelock -url
http://contoso.com -lock noaccess
stsadm -o setsitelock -url
http://contoso.com
http://contoso.com/
http://contoso.com/sites/ServicePWA
http://contoso.com/sites/ConsultingPWA
All Projects DB’s
whose site
collection exists
in the Content
DB
Use XXXXX_Published
Select RES_Name, RES_TYPE, RES_ID
from MSP_RESOURCES
where WRES_ACCOUNT =''
Update MSP_RESOURCES
set WRES_ACCOUNT = null
where WRES_ACCOUNT ='‘
Plan Upgrade
•
Setup New Project
2013 Farm
Upgrade to Project
Server 2010
Preparing Project
Server 2010
Backup and Restore
Content and Project
DBs
SharePoint Mount and
Upgrade Sites
• Plan for
•Clients
•Upgrading
customizations
•Multiple test cycles
• Review Hardware
requirements
• Plan new farm
topology
• SharePoint 2013 +
Project Server 2013
running
• Follow established
upgrade path from
previous versions of
Project
• Enable User AD
sync
• Check DB
Consistency and
ownership
• Disable BCM
• Content DB
• All associated
Project DB’s for sites
that exist in Content
DB
• Publish DB cleanup
•
Test
Post Migration
Enable PWA Feature
Mount and Upgrade
Project Web Instance
Upgrade and Mount
Project DB
Convert Project DB
//Test Content DB
//Mount Content DB
//Set site ownership for each PWA site
// Migrate users
//Test each PWA Site
//health check navigate to
http://contoso.com/sites/servicePWA/_layouts/15/setti
ngs.aspx
//Upgrade each PWA Sites
Plan Upgrade
•
Setup New Project
2013 Farm
Upgrade to Project
Server 2010
Preparing Project
Server 2010
Backup and Restore
Content and Project
DBs
SharePoint Mount and
Upgrade Sites
• Plan for
•Clients
•Upgrading
customizations
•Multiple test cycles
• Review Hardware
requirements
• Plan new farm
topology
• SharePoint 2013 +
Project Server 2013
running
• Follow established
upgrade path from
previous versions of
Project
• Enable User AD
sync
• Check DB
Consistency and
ownership
• Disable BCM
• Content DB
• All associated
Project DB’s for sites
that exist in Content
DB
• Publish DB cleanup
• Test Content DB
• Mount Content DB
• Migrate Claims
• Test PWA Sites
• Upgrade PWA Sites
Test
Post Migration
Enable PWA Feature
Mount and Upgrade
Project Web Instance
Upgrade and Mount
Project DB
Convert Project DB
//Convert 4x 2010 Project DB’s into a 2013 Project DB
ConvertTo-SPProjectDatabase
-WebApplication http://contoso.com
-Dbserver localhost
-ArchiveDbname PWA_Service_Archive
-DraftDbname PWA_Service_Draft
-PublishedDbname PWA_Service_Published
-ReportingDbname PWA_Service_Reporting
-ProjectServiceDbname PWA_Service
Plan Upgrade
•
Setup New Project
2013 Farm
Upgrade to Project
Server 2010
Preparing Project
Server 2010
Backup and Restore
Content and Project
DBs
SharePoint Mount and
Upgrade Sites
• Plan for
•Clients
•Upgrading
customizations
•Multiple test cycles
• Review Hardware
requirements
• Plan new farm
topology
• SharePoint 2013 +
Project Server 2013
running
• Follow established
upgrade path from
previous versions of
Project
• Enable User AD
sync
• Check DB
Consistency and
ownership
• Disable BCM
• Content DB
• All associated
Project DB’s for sites
that exist in Content
DB
• Publish DB cleanup
• Test Content DB
• Mount Content DB
• Migrate Claims
• Test PWA Sites
• Upgrade PWA Sites
Test
Post Migration
Enable PWA Feature
Mount and Upgrade
Project Web Instance
Upgrade and Mount
Project DB
Convert Project DB
• Convert 4 Project
DB’s into 1 new
Project DB
//Mount Project DB to Web Application
//Test each PWA Site
//Update Project Database
Upgrade-SPProjectDatabase –Name
–WebApplication
localhost
–DatabaseServer
Plan Upgrade
•
Setup New Project
2013 Farm
Upgrade to Project
Server 2010
Preparing Project
Server 2010
Backup and Restore
Content and Project
DBs
SharePoint Mount and
Upgrade Sites
• Plan for
•Clients
•Upgrading
customizations
•Multiple test cycles
• Review Hardware
requirements
• Plan new farm
topology
• SharePoint 2013 +
Project Server 2013
running
• Follow established
upgrade path from
previous versions of
Project
• Enable User AD
sync
• Check DB
Consistency and
ownership
• Disable BCM
• Content DB
• All associated
Project DB’s for sites
that exist in Content
DB
• Publish DB cleanup
• Test Content DB
• Mount Content DB
• Migrate Claims
• Test PWA Sites
• Upgrade PWA Sites
Test
Post Migration
Enable PWA Feature
Mount and Upgrade
Project Web Instance
Upgrade and Mount
Project DB
Convert Project DB
• Mount Project
Database
•Test Project
Database
• Upgrade Project
Database
• Convert 4 Project
DB’s into 1 new
Project DB
//Mount Project DB to Project Web App Instance
//Test each Project Web App instance
//Upgrades the Project Web App Instance
Upgrade-SPProjectWebInstance –Identity
Plan Upgrade
•
Setup New Project
2013 Farm
Upgrade to Project
Server 2010
Preparing Project
Server 2010
Backup and Restore
Content and Project
DBs
SharePoint Mount and
Upgrade Sites
• Plan for
•Clients
•Upgrading
customizations
•Multiple test cycles
• Review Hardware
requirements
• Plan new farm
topology
• SharePoint 2013 +
Project Server 2013
running
• Follow established
upgrade path from
previous versions of
Project
• Enable User AD
sync
• Check DB
Consistency and
ownership
• Disable BCM
• Content DB
• All associated
Project DB’s for sites
that exist in Content
DB
• Publish DB cleanup
• Test Content DB
• Mount Content DB
• Migrate Claims
• Test PWA Sites
• Upgrade PWA Sites
Test
Post Migration
Enable PWA Feature
Mount and Upgrade
Project Web Instance
Upgrade and Mount
Project DB
Convert Project DB
• Mount Project Web
Instance
•Test Project Web
Instance
• Upgrade Project
Web Instance
• Mount Project
Database
•Test Project
Database
• Upgrade Project
Database
• Convert 4 Project
DB’s into 1 new
Project DB
//Enable PWA feature
Plan Upgrade
•
Setup New Project
2013 Farm
Upgrade to Project
Server 2010
Preparing Project
Server 2010
Backup and Restore
Content and Project
DBs
SharePoint Mount and
Upgrade Sites
• Plan for
•Clients
•Upgrading
customizations
•Multiple test cycles
• Review Hardware
requirements
• Plan new farm
topology
• SharePoint 2013 +
Project Server 2013
running
• Follow established
upgrade path from
previous versions of
Project
• Enable User AD
sync
• Check DB
Consistency and
ownership
• Disable BCM
• Content DB
• All associated
Project DB’s for sites
that exist in Content
DB
• Publish DB cleanup
• Test Content DB
• Mount Content DB
• Migrate Claims
• Test PWA Sites
• Upgrade PWA Sites
Test
Post Migration
Enable PWA Feature
Mount and Upgrade
Project Web Instance
Upgrade and Mount
Project DB
Convert Project DB
• Turn on feature for
Project Site
collection
• Mount Project Web
Instance
•Test Project Web
Instance
• Upgrade Project
Web Instance
• Mount Project
Database
•Test Project
Database
• Upgrade Project
Database
• Convert 4 Project
DB’s into 1 new
Project DB
Post-upgrade tasks
Plan Upgrade
•
Setup New Project
2013 Farm
Upgrade to Project
Server 2010
Preparing Project
Server 2010
Backup and Restore
Content and Project
DBs
SharePoint Mount and
Upgrade Sites
• Plan for
•Clients
•Upgrading
customizations
•Multiple test cycles
• Review Hardware
requirements
• Plan new farm
topology
• SharePoint 2013 +
Project Server 2013
running
• Follow established
upgrade path from
previous versions of
Project
• Enable User AD
sync
• Check DB
Consistency and
ownership
• Disable BCM
• Content DB
• All associated
Project DB’s for sites
that exist in Content
DB
• Publish DB cleanup
• Test Content DB
• Mount Content DB
• Migrate Claims
• Test PWA Sites
• Upgrade PWA Sites
Test
Post Migration
Enable PWA Feature
Mount and Upgrade
Project Web Instance
Upgrade and Mount
Project DB
Convert Project DB
• Add Enterprise
Project Types
• Bulk Site Update
• Publish Projects
• Install/Review
Customizations
• Turn on feature for
Project Site
collection
• Mount Project Web
Instance
• Test Project Web
Instance
• Upgrade Project
Web Instance
• Mount Project
Database
• Test Project
Database
• Upgrade Project
Database
• Convert 4 Project
DB’s into 1 new
Project DB
Plan Upgrade
Setup New Project
2013 Farm
Upgrade to Project
Server 2010
Preparing Project
Server 2010
Backup and Restore
Content and Project
DBs
SharePoint Mount and
Upgrade Sites
• Plan for
•Clients
•Upgrading
customizations
•Multiple test cycles
• Review Hardware
requirements
• Plan new farm
topology
• SharePoint 2013 +
Project Server 2013
running
• Follow established
upgrade path from
previous versions of
Project
• Enable User AD
sync
• Check DB
Consistency and
ownership
• Disable BCM
• Content DB
• All associated
Project DB’s for sites
that exist in Content
DB
• Publish DB cleanup
• Test Content DB
• Mount Content DB
• Migrate Claims
• Test PWA Sites
• Upgrade PWA Sites
Test
Post Migration
Enable PWA Feature
Mount and Upgrade
Project Web Instance
Upgrade and Mount
Project DB
Convert Project DB
• Test
•Test
•Test
•And then test
more
• Add Enterprise
Project Types
• Bulk Site Update
• Publish all Project
• Turn on feature for
Project Site
collection
• Mount Project Web
Instance
• Test Project Web
Instance
• Upgrade Project
Web Instance
• Mount Project
Database
• Test Project
Database
• Upgrade Project
Database
• Convert 4 Project
DB’s into 1 new
Project DB
Learn
• Upgrade methods
• New capabilities
• Downtime mitigation
Validate
•
•
•
•
Prepare
Troubleshooting
Upgrade event failures
UI/UX issues
Data issues
•
•
•
•
Implement
•
•
•
•
Build/upgrade farms
Deploy customizations
Minimize downtime
Monitor progress
Document environment
Manage customizations
Plan upgrade strategy
Make items upgradable
Test
•
•
•
•
Build test farms
Use real data
Evaluate techniques
Find issues early
PC318 - Project Server 2013
Deployment Best Practices
from the field
Questions
MyPC fill out
evaluations
& win prizes!
www.msprojectconference.com