Difference between PJDB and PJSDB

[PeterNZ]

Hi,

I am using tables from the Project DB on the MS Project Server i.e.
MSP_Projects and MSP_Tasks to retrieve information.

I am a bit worried about whether I should have used the MSP_WEB_* tables and
not sure if there is a risk using the MSP_* tables instead. But I use data in
the table MSP_TEXT_FIELDS and there doesn't see an equvalent
MSP_WEB_TEXT_FIELDS.

So far I didn't have any problems and the data I retrieve from MSP_* tables
reflects the data I see in MS Project when I open a project from the server.
But for example I see the project name in MSP_WEB_PROJECTS as i.e. "APROJECT"
and in the MSP_PROJECTS table it is "APROJECT.Published" If I open a Project
in MS Project Client, I select "APROJECT" but in the title bar it says then
"APROJECT.Published".

Does this makes sense?

Regards

Peter

 

[Rod Gill]

The MSP tables are the tables that hold the information you see in Project
Professional. For Project Server, the reporting tables are MSP_VIEW They get
updated if not when you save, then when you re-publish.

 

[PeterNZ]

Thank you Rod.

So I should be ok if I use the MSP_PROJECTS table. I was just confused to
see a MSP_WEB_PROJECTS table.

Cheers

Peter

 

[Rod Gill]

Yes. Be very, very careful before editing it: know the pjdb.htm
documentation inside out first. All the MSP_Projects data should also be in
the MSP_VIEW tables. The VIEW tables are designed for reporting purposes and
are read only (well, data is only ever written to them, never read).

 

[PeterNZ]

Thanks Rod, I only read data from the database and update through the MS
Project Object Model.

You were very helpful.

Cheers

Peter