Connecting SAP ABAP AS post database migration from HANA 1.0 to HANA 2.0 on new hardware

[avijish]

Hi Experts,

We are migrating our SAP HANA database which consists of 1 SYSTEM and 2 tenant databases from HANA 1 SP12 on current hardware/server to new hardware/server(new IP Address/hostname) with HANA 2.0 SP05 using backup restore, the question is around the SAP Application connection settings post migration.

Will adapting the hdbuserstore connection settings to the new IP address & port numbers, be sufficient for the SAP Applications to connect to HANA 2.0 SP05 and resume or are there additional checks that need to be carried out (System copy. SWPM etc). The SAP Applications are compatible with both HANA 1 SP12 and HANA 2 SP05 latest revision as per SAP Product Availability Matrix. Please suggest and direct to SAP documentations if any.

Thanks in advance.

[lfdelacruz · Accepted solution]

Hi Vijish,

For application connection to the new DB server, you just need to adjust hdbuserstore as you did, as post-check, I would suggest you check the recommended HANA parameters for your new version - "HANA_Configuration_Parameters" in SAP note 1969700 - SQL Statement Collection for SAP HANA - and also update the HANA client in your application servers.

Regards,

Fernando de la Cruz.