The community will be in read-only from Monday 11:59pm (PT) to Wednesday 7:30am (PT)
The community will be in read-only from Monday 11:59pm (PT) to Wednesday 7:30am (PT)
Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Migrate PPM objects between different PPM versions

Highlighted
Utkarsh_Mishra
Honored Contributor

Migrate PPM objects between different PPM versions

Just for knowledge purpose.

 

There are cases in Project when we might need to deploy changes in difference PPM version, for example Satge/Dev is in SP7 where as Prod is in SP5 or any other version.

 

The PPM object migratior fails if the 2 PPM version (source and destination) are different.

 

One work around is to Open then zip content and modify the source_descriptor.xml file and change the versin value in xml file to that of the Destination PPM version. This solution is good if you need to mirgate 1 or 2 objects. 

 

But if you need to migrate more number of change then you can follow below solution.

 

-----------------------------------------------------------------------------------------------

 

Here is the trick to modify the source_descriptor.xml for migration purpose between different PPM version.

 

  1. Take backup of table knta_archives
  2. Run this SQL and save the value in any text file (this is to restore the changes once migration is completed)

    select VERSION   from   knta_archives
        where  BASE_FILENAME = 'knta_client'
        and    archive_type = 'jar';
  3. Identify the Destination PPM version value (either use below SQL or check source_descriptor.xml of destination PPM instance)

    select VERSION   from   knta_archives
        where  BASE_FILENAME = 'knta_client'
        and    archive_type = 'jar';

     Save the value as it will be needed. Say for example it 9,2,2,1294 (it will be comma instead of dot)



  4. Loging to Source PPM database
  5. Exceute this SQL 

    update knta_archives
    set  VERSION =   '9,2,2,1294' 
    where  BASE_FILENAME = 'knta_client'
          and  archive_type = 'jar'  

     

    Note: Make sure you execute it in Source PPM database, this will make the source_descriptor.xml file version same as that of destination PPM version.

  6. Commit the update transaction.
  7. Create the package and check the vesion in  source_descriptor.xml file
  8. Once all the packages are migrated, revert the changes i.e. update the version value in databse to previous value.

 

 -----------------OR------------------

 

Or vice-versa, you can modify destination version and then can migrate the change.

 

Enjoy!!!

Cheers..
Utkarsh Mishra

-- Remember to give Kudos to answers! (click the KUDOS star)
1 REPLY
Rash
Regular Collector

Re: Migrate PPM objects between different PPM versions

Thanks Utkarsh.. its useful

//Add this to "OnDomLoad" event