Sunday, August 3, 2008

4 in 1

Did you get the chance to explore the Project server Database, if yes then I am sure that you wonder why there are 4 databases created for each instance of the PWA. I will not answer why but I will till you in brief what is the purpose of each


  1. The Draft database contains tables for saving unpublished projects from Project Professional and other applications. Project Web Access does not show project data in the Draft database.
  2. The Published database contains all of the published projects as well as enterprise resources, the enterprise global template, and other project templates. Published projects are visible in Project Web Access. The Published database also contains tables that are specific to Project Web Access (timesheets, models, views, and so on), and global data tables (outline codes, security, and metadata).
  3. The Archive database saves backup and older versions of projects and other data.
  4. The Reporting database is the staging area for generating reports and OLAP cubes. Data in the Reporting database is comprehensive and is updated nearly in real time. The Reporting tables are optimized for read-only report generation.

For more details please read this article

Best Regards

Bilal Okour

No comments: