Getting data from MS Project Professional Database

[Jose M. Dominguez]

Hello:

I'm using Project Professional 2003 with Project Server 2003.

I want to retrieve from the Project database timescaled data for all
projects (work and actual work for different periods of time). I don't want
to use the MSP_WEB tables, instead I want to use the native Project
Professional tables, since what I need is the data as it is stored in each
project, and not the data from web access.

I've been looking through those Project tables trying to make a query to get
this kind of data, but I haven't succeed. I would appreciate suggestions to
get it.


Thank you
Jose M. Dominguez

 

[Jim Corbin [MSFT]]

See the Project 2003 SDK, "Extracting Timephased Data", in the Programming
Tasks section.

http://www.msdn.microsoft.com/libra.../pjsdkExtractingTimephasedData_HV01112435.asp

 

[Lars Hammarberg]

Unless you use the expand timephased data option in Tools/Options/Save from
within ProjectPro the tp data will be stored in the binary blob in the
MSP_PROJECTS table.
The easiest way of accessing that (from outside ProjectPro and just
accessing the database data) would be using the Project OLEDB provider,
which will give you a table for queries against timephased data - see the
oledb html file that ships with the product.