Ask about project server database

[Dolfi Besari]

Dear all,

I have some question about PWA Database. As we can see, there are four
database:
1.ProjectServer_Archive
2.ProjectServer_Draft
3.ProjectServer_Published
4.ProjectServer_Reporting

Any Body know what is each database used for?

When I insert a Task to a project, What database (and column) will be
affected?
When I publish the project, What database (and coulmn) will be affected?

Any body know a place where i can get this information?
I need this information because I have project which need connect to pwa
database.

Your help will be very appreciated.

Thank you.

 

[Stephen Sanderlin]

Connections to the Archive, Draft, and Published database are not
supported by Microsoft except in very limited circumstances and in a
very limited capacity. These databases are also not documented at all.
Reading from and/or writing to these databases is done at your own risk.
Be aware that Microsoft has been very clear that they reserve the right
to change the schema of these databases at any time and in whatever way
they wish. Furthermore, writing to these undocumented databases carries
a significant risk of data corruption. By doing so, you risk losing the
benefit of Microsoft's product support, as they have publically
indicated that damage or issues resulting from the violation of their
guidelines on this subject may move your system to an unsupported state.



However, the Reporting database is very well documented in the SDK. Feel
free to use that. If you need to access information in the other three
databases, you should use the PSI, which is also documented in the SDK.

--

Stephen Sanderlin

Principal Consultant

MSProjectExperts



For Project Server Consulting: http://www.msprojectexperts.com

For Project Server Training: http://www.projectservertraining.com



Read my blog at: http://www.projectserverhelp.com/

Join the community at: http://forums.epmfaq.com

 

[Gérard Ducouret]

Hello Dolfi

When the user saves his/her project : File / Save... the changed project
data go to the Draft database.
When the user publishes his/her project : File / Publish... the changed
project data go to the Published database.
The Report Data Service (RDS) transfers via a background process the data
from the Publish to the Reporting database.
The Archive data base is used for backups...

The affected columns are too numerous to be listed here...

Hope this helps

 

[Dolfi Besari]

Dear Stephen,

Thank for your respon.
You said that: the Reporting database is very well documented in the SDK.
Do you know where i can find this SDK since i'm very new to Project server

Thank you


"Stephen Sanderlin" <stephen NS-DOT sanderlin A-NS-T msprojectexperts DOT-NS com> wrote in message Connections to the Archive, Draft, and Published database are not supported by Microsoft except in very limited circumstances and in a very limited capacity. These databases are also not documented at all. Reading from and/or writing to these databases is done at your own risk. Be aware that Microsoft has been very clear that they reserve the right to change the schema of these databases at any time and in whatever way they wish. Furthermore, writing to these undocumented databases carries a significant risk of data corruption. By doing so, you risk losing the benefit of Microsoft's product support, as they have publically indicated that damage or issues resulting from the violation of their guidelines on this subject may move your system to an unsupported state.



However, the Reporting database is very well documented in the SDK. Feel free to use that. If you need to access information in the other three databases, you should use the PSI, which is also documented in the SDK.

--

Stephen Sanderlin

Principal Consultant

MSProjectExperts



For Project Server Consulting: http://www.msprojectexperts.com

For Project Server Training: http://www.projectservertraining.com



Read my blog at: http://www.projectserverhelp.com/

Join the community at: http://forums.epmfaq.com

 

[Dolfi Besari]

Waw.. merci Gerard..!

Let me try to finding out the table and column....

 

[Gary L. Chefetz]

Dolfi:

SDK = Software Developer's Kit and can be found on MSDN. Your two main sources for information on all Microsoft products are MSDN (MIcrosoft Developer's Network) and TechNet, which is designed for the IT professional (non-developer). For break/fix issues, use the Microsoft Knowledge Base. These are very important resources for anyone working with any Micrsosoft product. You'll want to get familiar with these right away!

--
----------
Gary L. Chefetz, MVP
MSProjectExperts
Project Server Consulting: http://www.msprojectexperts.com
Project Server Training: http://www.projectservertraining.com
Project Server FAQS: http://www.projectserverexperts.com
Project Server Help Blog: http://www.projectserverhelp.com


Dear Stephen,

Thank for your respon.
You said that: the Reporting database is very well documented in the SDK.
Do you know where i can find this SDK since i'm very new to Project server

Thank you


"Stephen Sanderlin" <stephen NS-DOT sanderlin A-NS-T msprojectexperts DOT-NS com> wrote in message Connections to the Archive, Draft, and Published database are not supported by Microsoft except in very limited circumstances and in a very limited capacity. These databases are also not documented at all. Reading from and/or writing to these databases is done at your own risk. Be aware that Microsoft has been very clear that they reserve the right to change the schema of these databases at any time and in whatever way they wish. Furthermore, writing to these undocumented databases carries a significant risk of data corruption. By doing so, you risk losing the benefit of Microsoft's product support, as they have publically indicated that damage or issues resulting from the violation of their guidelines on this subject may move your system to an unsupported state.



However, the Reporting database is very well documented in the SDK. Feel free to use that. If you need to access information in the other three databases, you should use the PSI, which is also documented in the SDK.

--

Stephen Sanderlin

Principal Consultant

MSProjectExperts



For Project Server Consulting: http://www.msprojectexperts.com

For Project Server Training: http://www.projectservertraining.com



Read my blog at: http://www.projectserverhelp.com/

Join the community at: http://forums.epmfaq.com