Function of microsoft project 2007 databases

M

mismym

Hi
I would like to know the description(the function, the content)of the MS
Project Server 2007 databases
Can somebody help me?
 
R

Rod Gill

Microsoft are deliberately not publishing them because they want to reserve
the right to change them if needed for any SP or hotfix. The reporting
database does have full descriptions (available in SDK). If you want to
programmatically update a project then either use Project VBA to update the
schedule then save and publish, or use the PSI interface, but this requires
a professional programmer.

If all you want to do is read data, then use the reporting database. I
recommend using as many of the built in Views as possible as they provide
better information than the tables. In particular the Project_user,
Task_User, Resource_User and Assignment_User Views are great as they also
include all Enterprise custom fields automatically.

--

Rod Gill
Project MVP

NEW!! Project VBA Book, for details visit: http://www.projectvbabook.com
 
M

mismym

Thanks
In fact I would like to build reporting on Projects data, in one company, it
is on Project 2000 and in another Project 2007.

I have two options:
first, create an external database for historical purpose, and build the
reports on it

second, use the reporting parts of Project (for both cases 2000 and 2007). I
would like to consider both.

As far as The second solution is concerned, Does that reporting part show
reports with an attractive layout? Is is possible to do drills (drill down,
up) on the date of the report?
For the first case, how can I externalise data for both Project 2000 and 2007.

P.S. I would like to precise that the dominant idea in both companies is to
externalise the data.

Thank you for your help
 
Top