Plan the database tier

  • Article

This Office product will reach end of support on October 10, 2017. To stay supported, you will need to upgrade. For more information, see , Resources to help you upgrade your Office 2007 servers and clients.

 

Topic Last Modified: 2016-11-14

This article identifies the key components of the database tier and helps you to distinguish from the parts of the other tiers in the EPM solution.

The database schema and access to Microsoft Office Project Server 2007 data is very different from the database schema used in Project Server 2003. The data access layer is internal to Office Project Server 2007 and is not exposed to external applications. The data access layer translates between the logical business entity representation of the data and the physical database tables. Each logical entity is stored in a number of different tables. The data access layer encapsulates the work required to manage connections, execute queries, and begin, commit, and roll back transactions. Office Project Server 2007 data is partitioned into four databases in Microsoft SQL Server:

  • The Draft database contains tables for saving unpublished projects from Microsoft Office Project Professional 2007. Project data in the Draft database is not accessible by using Microsoft Office Project Web Access.

  • The Published database contains all of the published projects. Published projects are visible in Office Project Web Access. The Published database also contains tables that are specific to Office Project Web Access (timesheets, models, views, and so on), and global data tables (outline codes, security, and metadata).

  • The Archive database saves backed-up and older versions of projects.

  • The Reporting database is the staging area for generating reports and online analytical processing (OLAP) cubes. Data in the Reporting database is updated nearly in real-time, is comprehensive, and is optimized for read-only report generation.

Only the Reporting database schema is documented. You should access the Drafts, Published, and Archive databases only through the Project Server Interface. You can add data tables, fields (properties), and entities that are not defined in the Office Project Server 2007 database schema. If you do, you must also provide the full stack of a custom assembly, Web service, business objects, and data access.

Download this book

This topic is included in the following downloadable book for easier reading and printing:

See the full list of available books at Downloadable content for Project Server 2007.