none
MSPS 2007: How to find team project association? RRS feed

  • Question

  • I have projects on MSPS 2007 that are connected to Team Projects (TFS). Can I get the association details in the database?

    Actually, I need to make queries in the TFS database for some work items associated to a project in MSPS 2007. How to do this?


    Does that helps?
    --------------------------------------------------------
    If you found this post helpful, please “Vote as Helpful”. If it answered your question, please “Mark as Answer”.
    Thanks,
    Kangkan Goswami |Technical Architect| Blog: http://www.geekays.net/
    http://in.linkedin.com/in/kangkan

    Tuesday, October 16, 2012 12:21 PM

All replies

  • TFS and Project Server are using two seperate databases.  You may be able to add a Link Server to one of the SQL databases and create SQL query joins between the two databases.

    Cheers!


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

    Wednesday, October 17, 2012 3:40 AM
    Moderator
  • @Michael: Please look at the query carefully. What I am asking is beyond the solution that you are proposing.

    What you are saying is already done. But look at the scenario:

    1. I have data in tables in the MSPS database for different projects

    2. I have data in tablef in the TFS database for different projects

    3. How can I fileter data from tables accross the databases for a single project? The name of project in the TFS database might not be the same as that of the MSPS.


    Does that helps?
    --------------------------------------------------------
    If you found this post helpful, please “Vote as Helpful”. If it answered your question, please “Mark as Answer”.
    Thanks,
    Kangkan Goswami |Technical Architect| Blog: http://www.geekays.net/
    http://in.linkedin.com/in/kangkan

    Wednesday, October 17, 2012 4:21 AM
  • Hi Kangkan --

    Since you already have the integration of TFS to project server may be via connector or your own custom solution. Well, Project server maintains the project site in ProjectWorkspaceInternalHRef column of MSP_EpmProject table  in reporting database & based on the URL/projectUid, you can get all information desired. Once you have the Project site/projUID URL,  you can get more information from TFS database.

    Apart from the above info, I would prefer to post the question forum dedicated to in TFS & project server integration.

    http://social.msdn.microsoft.com/Forums/en-US/tfsprojectsrvint/threads

    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, October 17, 2012 5:26 AM
  • Hi Amit,

    Can you elaborate on further steps? I get ProjectWorkspaceInternalHRef column of MSP_EpmProject table  in reporting database. It gives me the url of the site. But how does it give the linkage to the project table in TFS database?


    Does that helps?
    --------------------------------------------------------
    If you found this post helpful, please “Vote as Helpful”. If it answered your question, please “Mark as Answer”.
    Thanks,
    Kangkan Goswami |Technical Architect| Blog: http://www.geekays.net/
    http://in.linkedin.com/in/kangkan

    Wednesday, October 17, 2012 3:21 PM