Project server 2003 database scheme

[Rabbit]

All,

I want to directly get some of data from database of project server 2003,
where can I get the scheme about the database, I only can get the diagram
from Microsoft now, but it's not enough.

Thanks in advance,

Rabbit

 

[Brian K - Project MVP]

All,

I want to directly get some of data from database of project server 2003,
where can I get the scheme about the database, I only can get the diagram
from Microsoft now, but it's not enough.

Thanks in advance,

Rabbit

www.microsoft.com/downloads
Search the Project product for the word Schema and you get this page:
http://www.microsoft.com/downloads/...A3-F612-4DA2-ACB8-FDA8F850D645&DisplayLang=en

 

[Rabbit]

Thanks for your reply, but it's only diagram, what I need is the description
for each table and column.

 

[Brian K - Project MVP]

Thanks for your reply, but it's only diagram, what I need is the description
for each table and column.

Look for the prjsvrdb.htm file on your Project Server machine or on the
install CD.

 

[Yashr]

Check this.

http://www.microsoftproject.ru/articles.phtml?aid=38

and look for 'Database Tables'.

Thanks for your reply, but it's only diagram, what I need is the description
for each table and column.

 

[Brian K - Project MVP]

Check this.

http://www.microsoftproject.ru/articles.phtml?aid=38

and look for 'Database Tables'.

This is an exact cut and paste of the pjdb.htm file installed on your HD
when you install Project.
AND it is not the Project Server schema, it is the MS Project Schema.