We are in the process of migrating the WM platform from 6.1 to 7.1.2. We also need to migrate the runtime data as part of this upgrade. We had a created a new cloned SQL database instance from WM 6.1’s database and pointed the WM7.1.2 's JDBC pools to this new cloned SQL database backend.
We had noticed PRT and ISCore Audit tables (e.g: wmprocessstep,wmservice,wmserviceassoc,wmerror etc…) contain the serverId field. This field in the WM7.1.2 IScoreaudit and PRT tables still reflecting the old environment IP and port dedetails.
Can anyone suggset how to modify the server Id field for the WM PRT and Core Audit system tables so that it reflects the new environment details (Host IP , Port etc.)?