Assistance Required for Selective Schema Import in SAP HANA

[rahuljain257]

Greetings,

I am currently managing two databases. The first is named "SAP_Live", and the second is referred to as the "RFID_Live" schema. Within some of the stored procedures and functions, there is a reference to the "RFID_Live" schema, even though these procedures are housed within the "SAP_Live" database.

When performing an export of the "SAP_Live" schema from the SAP HANA system, it inadvertently includes the backup of the "RFID_Live" database as well.

My objective is to import only the "SAP_Live" schema, excluding the "RFID_Live" schema.

Thank you,
Rahul Jain

[HakanHaslaman · Accepted solution]

To import only the "SAP_Live" schema and exclude the "RFID_Live" schema in SAP HANA, try to Export the "SAP_Live" schema. Open the backup file and remove references to the "RFID_Live" schema. Save the modified backup file and import the modified backup file into the target system.

This should allows you to selectively import the desired schema and exclude the unwanted schema in SAP HANA.