Is there any documentation listing all the tables and field names for all Databases? in Project server 2010 RRS feed

  • Question

  • I need the table names and field names used in all 4 databasr versions of Project server 2010. where can I get that? thanks in advance
    Friday, March 23, 2012 7:11 AM


All replies

  • Hi there,

    Only the reporting database is documented as this is the only DB that is supported for direct T-SQL access. The Reporting DB details can be found in the SDK which is available for download here:




    Paul Mather | Twitter | http://pwmather.wordpress.com

    Friday, March 23, 2012 7:17 AM
  • Quote from white paper "Microsoft Project Server 2010". Now this link not working - where is actual link for this usefull content? May be author of this document (Andrew Lavinsky) know actual link?

    Tips and Tricks: Reporting Against the Database
    It is sometimes challenging for report authors to determine in which table a specific field is located.  The online database schema referenced above provides information on how to find fields.  Users may also refer to this helpful field finder tool developed by Treb Gatte of Microsoft Project Experts: http://reportmode.com/psrdb_reference. 


    Friday, March 23, 2012 9:04 AM
  • Hi,

    The online database schema that was on Reportmode is the same as the information in the SDK that Paul pointed you to. Unfortunately reportmode is no longer around, but the SDK is.


    Alex Burton
    www.epmsource.com | Twitter
    Project Server TechCenter | Project Developer Center | Project Server Help | Project Product Page

    Monday, April 2, 2012 7:20 AM