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 Link to the Original Product-Provided Name

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

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

You execute a SQL statement to change the Relationship Template Link Name. Perform these steps for each entry in the report with status ‘Rename to migrate’ and a value that is specified under ‘Link 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_linkdef
   SET ndtext = '{Link Rename}'
   WHERE ndtext = '{Link Name}'
   

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

2. Replace the placeholders with the values in the same-named columns on the Relationship Report. For example, in the report, the Link Rename column identifies the product-provided template link name as Approved by. You replace {Link Rename} with Approved by.