Where Does Project Server Data Get Stored

[Ken Popkin]

We are in the process of implementing Microsoft Project Server 2003. To
date I have completed the following:
1. Added four resources to the Enterprise Resource Center.
2. Created and published a project to the server with two tasks, that used
two resources from the Enterprise Resource Center.

In Project Web Access as a user with Administrative rights, I can view the
four resources and the project that I created. Based on this I am assuming
that everything worked correctly with regard to the way I created the
resources and published the workplan using Project Professional.

I would like to know the following:

1. When I used SQL's Enterprise Manager to look at the underlying database
I was surprised to find six project server databases labeled ProjectServer,
ProjectServer2185, ProjectServer6028, ProjectServer6405, ProjectServer9232,
and ProjectServer9880. Why are there six project server databases and which
one is storing the data?

2. What tables are being used to store the data. I looked in MSP_Resources
and MSP_Projects, but didn't find any of my data?

3. Are there any write-ups that explain the database schema?

4. The reason I am asking is that we may want to write some of our own
stored procedures to extract data. Is this a good approach or should I
stick with the API's that are mentioned in the documentation?

Thanks in advance for your help.

Ken.

 

[Mike Glen]

Hi Ken,

Try posting on the server newsgroup. Please see FAQ Item: 24. Project
Newsgroups. FAQs, companion products and other useful Project information
can be seen at this web address: http://www.mvps.org/project/.

Mike Glen
Project MVP

 

[rom]

----- Ken Popkin wrote: ----

I would like to know the following

1. When I used SQL's Enterprise Manager to look at the underlying databas
I was surprised to find six project server databases labeled ProjectServer
ProjectServer2185, ProjectServer6028, ProjectServer6405, ProjectServer9232
and ProjectServer9880. Why are there six project server databases and whic
one is storing the data

That means, the Project server was installed several times already. (install, uninstall, install, uninstall ...
If you did it in one, you should only have "ProjectServer"

2. What tables are being used to store the data. I looked in MSP_Resource
and MSP_Projects, but didn't find any of my data

It's a relational database. Data for one project are spread in several tables

3. Are there any write-ups that explain the database schema

There's a link somewhere that documents the DB schema in visio format. Haven't found an explanation yet either

4. The reason I am asking is that we may want to write some of our ow
stored procedures to extract data. Is this a good approach or should
stick with the API's that are mentioned in the documentation

It's best to go with API's rather than a direct link to the database

Thanks in advance for your help

Ken