none
Project Server Data Bases RRS feed

  • Question

  • Hi, 

     I need, an example of Archive and Publish Data base, to do some reporting test on Project Server 2010, thank you.

    Wednesday, August 1, 2012 10:03 AM

Answers

  • Please see my previous reply:
    "Only Reporting database schema is documented & It's in SDK. " If you want to get/update the data in Drfat/published database, You will need to use PSI (Web service) of Project server.

    Hope that helps.


    If you found this post helpful, please “Vote as Helpful”. If it answered your question, please “Mark as Answer”. Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82

    • Marked as answer by NIKRAJ Friday, August 3, 2012 10:13 AM
    Friday, August 3, 2012 9:47 AM

All replies

  • Hi Nikraj--

    As per Microsoft support, Developers are strongly discouraged from directly accessing the Draft, Published, or Archive Project Server database through Microsoft SQL Server queries. Making direct changes in the Project Server database tables can damage referential integrity and interfere with database access through the Project Server Queuing Service.

    Applications that directly access the Draft, Published, or Archive database also are dependent on the database schemas, which can change in service packs or later versions of Project Server 2010. Furthermore, applications that directly access the databases lose the built-in Project Server security, common business logic, tracking, audits, error checking, reporting, workflow, and other features. You would likely need to rewrite such an application for Project Server 2010 updates. 
    http://msdn.microsoft.com/en-us/library/ms504195.aspx

    You may need to use the PSI to get the data from Published/Draft/Archive  database. 
    http://msdn.microsoft.com/en-us/library/office/ee767707.aspx


    i
    f you tell use what data you are looking in project server, We can help to find the same in reporting database if possible.

    Hope that helps.


    If you found this post helpful, please “Vote as Helpful”. If it answered your question, please “Mark as Answer”. Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82


    Wednesday, August 1, 2012 10:54 AM
  • Hi Amit  Khare

    I'm looking for an example of Databases which content information about project : budget, resources, cost of project .... 

    actually, I have no data in the project server Data bases.


    Wednesday, August 1, 2012 11:34 AM
  • Hi there--

    You will need to save & publish a project plan using MS project/PWA. Once the project is published, You can get the data from Reporting database.

    Would suggest to download the Project Server SDK & see the database schema for reporting database.
    http://www.microsoft.com/en-us/download/details.aspx?id=15511

    You should be able to get the Project data from Reporting database Project user view.

    Hope that helps.


    If you found this post helpful, please “Vote as Helpful”. If it answered your question, please “Mark as Answer”. Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82

    Wednesday, August 1, 2012 11:56 AM
  • Hi 

    I'm now in internship period, I have just installed the project server 2010. the  company  does not have information about project in project databases " Publish, archive or reporting". Databases are empty.

    I want to do self-training, so  I need Archive or reporting  databases   for test 

    thak you  M. Amit  Khare

    Wednesday, August 1, 2012 12:11 PM
  • If you have project server 2010 installed. You can create test project(s) & run the SQL queries. 

    I haven't seen any samples for Project server 2010 databases, but you can download the PS2007 databases & attach on your SQL server to understand. It will help you to learn the PS2010 since there is not a huge difference.
    http://archive.msdn.microsoft.com/PS2007SampleDB/Release/ProjectReleases.aspx?ReleaseId=1044

    Hope that helps.


    If you found this post helpful, please “Vote as Helpful”. If it answered your question, please “Mark as Answer”. Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82

    Wednesday, August 1, 2012 12:17 PM
  • I think, it  can be usefull

    an other question please, you know that project server has 4 databases, Draft, Archive, recording & publish.
    these Databases have already specific tables? which means there are specific tables, columns, views..... 

    can I have documentation about the Metadata  of these Databases 

    thank you  M. Amit  Khare

    Wednesday, August 1, 2012 12:48 PM
  • Good. Only Reporting database schema is documented & It's in SDK.
    As stated earlier, Would suggest to download the Project Server SDK & see the database schema for reporting database.
    http://www.microsoft.com/en-us/download/details.aspx?id=15511

    Hope that helps,


    If you found this post helpful, please “Vote as Helpful”. If it answered your question, please “Mark as Answer”. Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82

    Wednesday, August 1, 2012 2:19 PM
  • Thank you M. Amit  Khare
    Thursday, August 2, 2012 9:41 PM
  • You are more than welcome :) . If you found this post helpful, please “Vote as Helpful”. If it answered your question, please “Mark as Answer” and close the thread. 

    Thanks,


    If you found this post helpful, please “Vote as Helpful”. If it answered your question, please “Mark as Answer”. Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82

    Friday, August 3, 2012 5:17 AM
  •  you do not have documentation about  Archive and publihsed schemas of project server 2010, 

    the archive and published Schemas (tables , columns, views) of 2010 and 2007 are the same??

    thank you,

    Friday, August 3, 2012 9:39 AM
  • Please see my previous reply:
    "Only Reporting database schema is documented & It's in SDK. " If you want to get/update the data in Drfat/published database, You will need to use PSI (Web service) of Project server.

    Hope that helps.


    If you found this post helpful, please “Vote as Helpful”. If it answered your question, please “Mark as Answer”. Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82

    • Marked as answer by NIKRAJ Friday, August 3, 2012 10:13 AM
    Friday, August 3, 2012 9:47 AM