none
Project Server 2013 reporting database change in Schema from Project Server 2010 RRS feed

  • Question

  • I have a current Project Server 2010 implementation, I am planning to migrate to Project Online.

    We have Customized Reports that consume from the PS 2010 Reporting DB.

    Are there differences in the Reporting DB schema  between PS 2010 and Project Online?

    My Question is: if we migrated to Project Online, will the reports crash?

    Another question is that, is PS 2013 Reporting DB schema the same as Project Online?

    Saturday, January 18, 2014 1:54 PM

Answers

  • Hi Atia,

    IN project server 2013 we have only one database instead of 4, it means draft, archive, published and reporting with in one database.Project Server 2013 reporting database schema tool that can be downloaded.

    http://blogs.msdn.com/b/project_programmability/archive/2013/01/28/project-server-2013-reporting-database-rdb-schema-reference.aspx

    There are differences in reporting of on-premises vs. Project Online

    The Project Server 2013 reporting schema includes three new tables, 27 new views, and a total of 33 tables and views that include new fields.

    Answer-1 : Yes there are some differences between PS 2010 and project Online.

    Answer-2 : Reports will crash as In Project Online you have to use ODATA to create report. You can not query project online data for reporting directly you have to have use ODATA. 

    http://msdn.microsoft.com/en-us/library/jj163015.aspx

    Answer-3 : NO, PS 2013 Schema and Project online Schema is different. 

     



    kirtesh

    • Marked as answer by Mohamed Atia 8 Thursday, January 30, 2014 10:46 AM
    Saturday, January 18, 2014 5:43 PM
  • Hi Mohammed,

    You will not be able to migrate 2010 reports as they are. Be aware that with Project Online, you have to use ODATA reporting from Excel. Then be aware also that there is no more 4 DB but 1 in PS2013, evenif the scheme is kept similar.

    Here are some links:

    • http://blogs.office.com/b/project/archive/2012/10/31/reporting-project-server-pwa-odata.aspx
    • http://blogs.office.com/b/project/archive/2013/03/29/project-online-and-excel-web-app-cloud-data-improves-reporting.aspx
    • http://blogs.technet.com/b/projectsupport/archive/2013/08/30/project-online-updating-odata-connections-in-excel-for-different-pwa-instances.aspx

    Hope this helps.


    Guillaume Rouyre - MBA, MCP, MCTS


    Saturday, January 18, 2014 5:18 PM
    Moderator

All replies

  • Hi Mohammed,

    You will not be able to migrate 2010 reports as they are. Be aware that with Project Online, you have to use ODATA reporting from Excel. Then be aware also that there is no more 4 DB but 1 in PS2013, evenif the scheme is kept similar.

    Here are some links:

    • http://blogs.office.com/b/project/archive/2012/10/31/reporting-project-server-pwa-odata.aspx
    • http://blogs.office.com/b/project/archive/2013/03/29/project-online-and-excel-web-app-cloud-data-improves-reporting.aspx
    • http://blogs.technet.com/b/projectsupport/archive/2013/08/30/project-online-updating-odata-connections-in-excel-for-different-pwa-instances.aspx

    Hope this helps.


    Guillaume Rouyre - MBA, MCP, MCTS


    Saturday, January 18, 2014 5:18 PM
    Moderator
  • Hi Atia,

    IN project server 2013 we have only one database instead of 4, it means draft, archive, published and reporting with in one database.Project Server 2013 reporting database schema tool that can be downloaded.

    http://blogs.msdn.com/b/project_programmability/archive/2013/01/28/project-server-2013-reporting-database-rdb-schema-reference.aspx

    There are differences in reporting of on-premises vs. Project Online

    The Project Server 2013 reporting schema includes three new tables, 27 new views, and a total of 33 tables and views that include new fields.

    Answer-1 : Yes there are some differences between PS 2010 and project Online.

    Answer-2 : Reports will crash as In Project Online you have to use ODATA to create report. You can not query project online data for reporting directly you have to have use ODATA. 

    http://msdn.microsoft.com/en-us/library/jj163015.aspx

    Answer-3 : NO, PS 2013 Schema and Project online Schema is different. 

     



    kirtesh

    • Marked as answer by Mohamed Atia 8 Thursday, January 30, 2014 10:46 AM
    Saturday, January 18, 2014 5:43 PM
  • Thanks a lot Guillaume and Kirtesh.

    That really helped. Chapeau

    Saturday, January 18, 2014 10:28 PM
  • The project server 2013 schema is found in the project server 2013 SDK

    http://www.microsoft.com/en-us/download/details.aspx?id=30435

    Cheers!


    Michael Wharton, MVP, MBA, PMP, MCT, MCTS, MCSD, MCSE+I, MCDBA
    Website http://www.WhartonComputer.com
    Blog http://MyProjectExpert.com contains my field notes and SQL queries

    Sunday, January 19, 2014 2:14 AM
    Moderator