MS Project Server Tables Diagram

[Nock]

I have a copy of the MS Project Client tables diagram but is there a similar
diagram that shows the relationship between tables in the Project Server
environment?

Too complex?

(For reference, I have copies of PJDB.HTM, PJSVRDB.HTM and PROJERD.HTM
already)

Many thanks,

Nock

 

[Dale Howard [MVP]]

Nock --

You are so close, and yet so far away! You need the Weberd.htm file,
available for download at the following URL:

http://www.microsoft.com/downloads/...75-1367-4b66-870d-f280c054efe2&DisplayLang=en

Hope this helps.

 

[Nock]

Thanks Dale, much appreciated.

Another question thou, how do the tables at the Project Client level
interact with the tables at the Project Server level?

I assume that the client tables together form the basic project structure
and the Server tables manipulate and splice this infomation (ie. provide
various views and add enterprise level data etc)? Am I close?

Is there a clear explanation of how these interact?

Love your work Dale.

Cheers,
Nock (Newb)

 

[Nock]

Sorry Dale - another question.

Where are the Enterprise Outline codes represented on these diagrams? I
can't see a ref to these on either (Project Client or Server) Tables.

Thankyou,

Nock

 

[Dale Howard [MVP]]

Nock --

I'm not a DBA professionally, so please understand this is a very simple
explanation of the SQL Server tables in Project server:

The system stores project data in a collection of tables labeled with the
prefix "msp_." The system populates these project tables each time the
project manager saves a Microsoft Project plan in the Project Server
database.



When the project manager publishes a project to Project Web Access, the
system stores the published data in a collection of tables labeled with the
prefix "msp_web."



Each time the system processes the OLAP Cube, it stores the data in a
collection of tables labeled with the prefix "msp_cube."



The system stores data used for the processing of business and presentation
logic in Project Web Access in a collection of tables labeled with the
prefix "msp_view."



Please keep in mind that this is a very simple explanation of the Project
Server database. Since you are a newbie, please refer to the following FAQ
about documentation and training on Project Server 2003:



http://www.projectserverexperts.com/Shared Documents/PS2003Documentation.htm


Hope this helps.

 

[Dale Howard [MVP]]

Nock --

How about MSP_OUTLINE_CODES and MSP_CODE_FIELDS in the projerd file?

 

[Nock]

Thanks Dale, I now vaguely recall reading about the four table sets that
comprise the Project Server database. Back into the books. Thanks for the
direction, much appreciated.

Nock

 

[Dale Howard [MVP]]

Nock --

You are more than welcome, my friend.