none
How to migrate data from CA Clarity PPM into Project Server 2013? RRS feed

  • Question

  • Is there an easy way to migrate data from CA Clarity PPM into Project Sever 2013? any existing tools available?

     I saw in one of the older posts that one can  export Clarity Projects to MS Project. Save the projects; Using MS Project Sync those Projects into Project Server. Repeat this for all projects."

    but what about custom fields? Plus, it will take a very long time to do all that per each project if there are a lot of projects. did anyone done that by doing inserts from one DB to another? or a separate .NET application needs to written?

    Tuesday, January 14, 2014 7:27 PM

Answers

  • Custom fields could be copied from Clarity providing there is an API / database you can access to get the details from Clarity, you would then need to use the PSI/ Project Server CSOM to add those fields in to Project Server. You do the same thing with projects, then programmatically create the projects in Project Server using the PSI / CSOM. As this would be a one off exercise it would probably be quicker to migrate everything manually rather than write the code and test it to do this programmatically.

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com | CPS

    Tuesday, January 14, 2014 9:48 PM
    Moderator

All replies

  • Tuesday, January 14, 2014 7:34 PM
  • Custom fields could be copied from Clarity providing there is an API / database you can access to get the details from Clarity, you would then need to use the PSI/ Project Server CSOM to add those fields in to Project Server. You do the same thing with projects, then programmatically create the projects in Project Server using the PSI / CSOM. As this would be a one off exercise it would probably be quicker to migrate everything manually rather than write the code and test it to do this programmatically.

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com | CPS

    Tuesday, January 14, 2014 9:48 PM
    Moderator
  • In addition to what Paul already mentioned, there is no easy way to migrate everything, projects you can migrate by exporting and doing a sync but for custom fields you will need a custom solution to get everything migrated, and depending upon no of projects & custom fields data volume being migrated along with no of environments you can decide wether a custom solution would be worth writing or it would take less effort to do it manually

       

    Thanks | Sunil Kr Singh | http://epmxperts.wordpress.com

    Wednesday, January 15, 2014 4:05 PM
    Moderator