How to Migrate CA APM Data from Release 11.3.4 to Release 12.8 › How to Migrate CA APM Data from Release 11.3.4 to Release 12.8 › Run the Pre-Migration Reports › Pre-Migration Report Data for Reference and Corrective Action › Relationship Report › Change the Renamed Relationship Template to the Original Product-Provided Name

Change the Renamed Relationship Template to the Original Product-Provided Name

Before you run the Migration Utility, you change the renamed Relationship Template names to the original product-provided Relationship Template names from Release 11.3.4.

You execute a SQL statement to change the Relationship Template Name. Perform these steps for each entry in the report with status ‘Rename to migrate’ and a value that is specified under ‘Relationship Template Rename’.

Follow these steps:

1. Execute the following SQL statement from your preferred tool (for example, Microsoft SQL Server Management Studio or Oracle SQL Developer):

   Note: The brackets and the text within the brackets are placeholders. The placeholder names represent the column names on the Relationship Report.

   UPDATE arg_actiondf
   SET adtext = '{Relationship Template Rename}'
   WHERE adtext = '{Relationship Template Name}'
   

   AND ad1obty IN (SELECT slentry
   	FROM arg_strlst
   	WHERE slid = 9
   	AND slvalue1 = '{Relationship Object Type}')
   

2. Replace the placeholders with the values in the same-named columns on the Relationship Report. For example, the report Relationship Template Rename column identifies the product-provided name Activity Summary. You replace {Relationship Template Rename} with Activity Summary.