Project Server question - getting information out

[billd]

Hi,
I need to get information from Project Server database and insert them into
an external database. I’ve been digging through the PS db for last two days
and I’m still confused.
My problem is that I cannot find all information or I’m not able to link the
columns.
I know that table MSP_PROJECTS contains PROJ_ID and PROJ_NAME.
Table PSP_ATTRIBUTE_STRINGS contains names of the extra created columns and
table MSP_TEXT_FIELDS their values.
I don’t know how to link these two tables.
Any idea?
Thanks,
b.

 

[Kevin W Flanagan]

You need to use the ID fields for the attributes and the text field. They
will match up.