- Microsoft Project Server Database Schema Table Name
- Microsoft Project Server Database Schema Table Hierarchy
- Microsoft Project Server Database Schema Table 2017
- Microsoft Project Server Database Schema Tables
- Microsoft Project Server Database Schema Tables
Project server 2010 Reporting Database Schema. Project Server General. Database that shows all the fields with their tables and relations. MS Project data in SQL Server. Another option I see is to use kind of automation around MS Project which will load project plan, extract all interested information and upload to to your database. There is no big magic in this solution. The third option is to export projects to XML and then use the XML to upload data to SQL Server database.
I am working on a project of interaction between Ms project server 2010 And Google apswhat i had to do is :every time you add a task on Ms project server and you assign to someone ( by adding his resource to the task) ... the task should appear his Google agenda
what i need to do is read some specific attribute from database of Ms project server 2010 ( such as name of task,when it starts , name of project ..) ,but when i open the database using sql server i found that it contains lot of tables , i want to know if there s any documents that explain the whole structure (MCD) and data dictionary .
and thank you
2 Answers
You can use Draft, Published and Reporting databases. But only Reporting is documented and recommended by Microsoft for direct access. You can find its schema in Project 2010 SDK: http://www.microsoft.com/en-us/download/details.aspx?id=15511
Other option is using Project Server event handlers and PSI.
Microsoft Project Server Database Schema Table Name
I don't have a document for you... but I do have some code you may find helpful:
Microsoft Project Server Database Schema Table Hierarchy
MPXJ provides a database reader which will read project data from MS Project MPD databases, and Project Server SQL Server databases (they share a very similar structure). You can either use MPXJ itself abstract the mechanics of reading the data from the database, or you can dive in to the source to see how the tables and columns work, then produce your own queries.
If you want to take the latter approach, you'll find the select statements from the various tables live in the MPD9DatabaseReader class. The result sets are processed in the MPDAbstractReader class.
Jon IlesMicrosoft Project Server Database Schema Table 2017
Jon IlesMicrosoft Project Server Database Schema Tables
