logo-sharepoint-4 logo-sharepoint-2logo-sharepoint-3

Jones Professional Services is a Microsoft Certified Partner delivering SharePoint / Project Server 2016, Enterprise Project Management solutions and now the release of SharePoint Server 2016.

Project Server 2013 Databases

In the 2010 version, each Project Server 2010 instance was supported by a set of four Project Server databases (Draft, Publish, Reporting, and Archive).
For Project Server 2013 Preview, all four Project Server 2013 Preview databases are consolidated into a single database, the Project Web App database (default name: ProjectWebApp). The Reporting tables retain their previous names, and the Draft, Published, and Archived table names have the prefixes draft., pub., and ver. Direct access is not supported for the Draft, Published, and Archive tables and views.
As with 2010 reporting db reporting should only use the Reporting tables and views.
These changes are driven by the need to reduce total cost of ownership (TCO) for using Project Server 2013 Preview, especially when you are implementing an environment in which you may have multiple PWA instances in your environment. A reduction in the number of databases required to use Project Server 2013 Preview reduces the costs associated to maintain the data (update, backup, disaster recovery, and so on).

08/02/2012 - 5:30pm