none
Import MPP file into SQL server 2008 RRS feed

  • Question

  • Hi All,

    Is there any direct way to importing .MPP (project professional file) to SQL server 2008. I dont want to use project server.

    I dont want to use any third party software for that. Any Idea
    Tuesday, August 2, 2011 8:01 AM

Answers

  • Hi Kamal,

    There is no such way to "direct import" project file to SQL server.

    Also Project Server only use SQL as a data repository, there are lot of project related activities such as reminders/time-lines/views/tasks etc. etc. that only Project Server do based on that data. So basically having data residing in some data base server would be of no use.

    In case you are looking to keep your project file on some shared location, you can do this using sharepoint. Also if you have sharepoint 2010 in your organization, you can also share your project plan to the sharepoint site to share it with other team members.

    Let me know if you need any more help related to the above.

    hope this helps.


    | Khurram Jamshed | Follow my blog about Enterprise Project Management Solution | http://khurramjamshed.blogspot.com |
    Tuesday, August 2, 2011 8:54 AM
  • Could you please explain a bit more about the actual requirement ?

    what do you want to do with converting project the file to xml ? No doubt that you can do wonders while having Project and SharePoint work together. 

    you can see this white paper about sharepoint and project together: http://www.microsoft.com/download/en/details.aspx?id=8821

    Also see this project 2010 sync capability with sharepoint 2010 and how it can benefit you: http://blogs.msdn.com/b/project/archive/2009/10/19/project-2010-introducing-sync-to-sharepoint.aspx

    If you can share more detail, i would definitely be able to help you more.

    hope this helps.


    | Khurram Jamshed | Follow my blog about Enterprise Project Management Solution | http://khurramjamshed.blogspot.com |
    Tuesday, August 2, 2011 10:07 AM

All replies

  • Hi Kamal,

    There is no such way to "direct import" project file to SQL server.

    Also Project Server only use SQL as a data repository, there are lot of project related activities such as reminders/time-lines/views/tasks etc. etc. that only Project Server do based on that data. So basically having data residing in some data base server would be of no use.

    In case you are looking to keep your project file on some shared location, you can do this using sharepoint. Also if you have sharepoint 2010 in your organization, you can also share your project plan to the sharepoint site to share it with other team members.

    Let me know if you need any more help related to the above.

    hope this helps.


    | Khurram Jamshed | Follow my blog about Enterprise Project Management Solution | http://khurramjamshed.blogspot.com |
    Tuesday, August 2, 2011 8:54 AM
  • Khurram Jamshed,

    Thanks for your reply..

    I only need to import .mpp file in sql . Rt now i am doing this by exporting .mpp file in XML and than importing in SQL but unable to convert the Database tables in XML format. Any ways.. Is there some way in sharepoint 2010. We have that in our company.

    Regards,

    Kamal Pundir

    Tuesday, August 2, 2011 9:00 AM
  • Could you please explain a bit more about the actual requirement ?

    what do you want to do with converting project the file to xml ? No doubt that you can do wonders while having Project and SharePoint work together. 

    you can see this white paper about sharepoint and project together: http://www.microsoft.com/download/en/details.aspx?id=8821

    Also see this project 2010 sync capability with sharepoint 2010 and how it can benefit you: http://blogs.msdn.com/b/project/archive/2009/10/19/project-2010-introducing-sync-to-sharepoint.aspx

    If you can share more detail, i would definitely be able to help you more.

    hope this helps.


    | Khurram Jamshed | Follow my blog about Enterprise Project Management Solution | http://khurramjamshed.blogspot.com |
    Tuesday, August 2, 2011 10:07 AM