Project Server DBs

[Elsa L.]

Hello,
I have some OLAP cubes implemented over Project Server 2003 and I am in the
migration process to 2007 and I need to figure out where is the data I need...
Can anyone clarify me how does Project Server DBs organization works?
I have:

ProjectServer_Published
ProjectServer_Draft
ProjectServer_Archive
ProjectServer_Reporting

Am assuming that for example when I save something to a project those things
will be inserted in the _Draft DB, if I publish them do they go to both
_Draft and _Published. When I _Archive one project is it deleted from
_Published and/or _Draft and is inserted in _ Archive?...

Thank you in advance!
Elsa

 

[Gérard Ducouret]

Elsa,
Please find hereafter an excerpt of the Microsoft documentation:


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.

hope this helps,

Gérard Ducouret

 

[Elsa L.]

Thank you very much Gerard. I will explore the documentation.

Elsa