Project Server 2002 Database Schema Diagram

[Jennifer]

I am attempting to extract data directly from the Project
2002 database. Does anyone know where I can find a
useful database schema diagram?

 

[Michelle]

See below site:

http://www.microsoft.com/downloads/details.aspx?
FamilyID=1bbd165e-cae4-4a0a-bb2d-
9ad0238dc23b&DisplayLang=en

Michelle

 

[Deepu Chacko]

There is a html file called projdb.htm on the machine where project server
is installed....

This file has the complete information about the database. Incase u dont
have it, let me know and I shall zip it and send it across to u over email..

 

[Greg Horodeck]

There are actually two schemas for all of the tables in the database; the
Project Professional side and the Web side

For the schema diagrams, look in:
http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechn
ol/project/project2002/reskit/toolbox/tbdbref.asp

For the documentation, look in PROJDB.HTM and SVRDB.HTM located on your
Project Server CD and installed on your Project Server.


Greg




I am attempting to extract data directly from the Project
2002 database. Does anyone know where I can find a
useful database schema diagram?