SQL table structure for project server

[Manmeet Chaudhari]

HI
i have a third party application which i want to integrate with project
server so as to generate desired reports.
For tht i need to know the table structure of SQL and the relationships
associated.

What will be the best place to refer for such a need.
Kindly suggest

 

[Rod Gill]

Hi,

The pjsrvrdb.htm file installed with Project Server is the place to look.
However, it is not advised to add to or edit any of the project server
tables. Corruptions are likely as key information is often in binary blobs
whose structure hasn't been made available.

Safest way to interact with Project Server is via PDS but PDS has gone in PS
2007. If all you want to do is read data, then use the MSP_VIEW tables. In
PS 2007 these are part of the new reporting database.

 

[FaisalM]

Check these documents from MS

1. Project Server 2003 Database Schema
http://tinyurl.com/zzu8t

2. Project Server 2003 In-Box Documentation
http://tinyurl.com/keucr

--
FaisalM
http://www.FaisalMasood.com/

My Project Blog
http://msp.faisalmasood.com/
My Sharepoint Blog
http://sps.faisalmasood.com/