none
What Datanbase for Microsoft Project RRS feed

  • Question

  • Goal:
    Review the raw data of project in SQL server. The project is created in Microsoft Project.
    Raw data is for instance milestone, date time, task list, start date, end date etc.

    Problem:What database and table should I review in SQL Server?

    Friday, April 19, 2013 11:33 AM

All replies

  • Hi,

    What Version of Project Server are we talking about? Project Server 2003 had for instance 1 Database for Project Data. Project Server 2007 and 2010 have 4 Databases (Archive, Draft, Published and Reporting DB) and Project Server 2013 has again 1 Database for the Project Server Data.

    To get out your information from the Database I would recommend you to use the ProjectServer_Reporting Database on Project Server 2007 or 2010 and the same tables which have remained their names in 2013. The Change of the 2013 Database which is named now ProjectWebApp is that you find the Tables of the former 3 Databases (Archive, Draft and Pulished) named now with a prefix ver., draft. and pub..

    Please see http://technet.microsoft.com/en-us/library/ff631142.aspx#section4 for further reference to this.

    In the Reporting Database are ALL Project Server Data avalable so you would for sure find what you are looking for. The correct select query depends a little bit from the exact data you want to have out of it but Reporting DB is the place to go. The Data you are looking for might be splitted in various tables.

    Cheers

    Thomas

    Friday, April 19, 2013 12:12 PM
  • If you need all data about your projects, you can go to ProjectServer_Reporting database, expand Views and open view called dbo.MSP_EpmProject_UserView.

    Here you will find all your project and its data. If you click on that view's design, you can see in which tables data is actually stored.

    Friday, April 19, 2013 2:24 PM
  • Sakura,

    I've published a high level ERD for the Reporting database, along with the recommended views/tables to use here: http://aboutmsproject.com/database-diagramsproject-server-reporting-database/

    Hope this helps.

    Treb Gatte | @tgatte | http://AboutMSProject.com

    Saturday, April 20, 2013 12:00 AM
    Moderator