HDI Container name renaming and content migration in SCP Cloud Foundry

[fabianorosa]

Hi all,

Is possible rename a HDI Container (service instance and the DB related objects) in the SCP Cloud Foundry? If not, how can I migrate a content (database objects and data) from a HDI Container (ex: app1_shared_hdi) to other HDI Container (ex: app2_shared_hdi)?

Regards,

Fabiano Rosa

[thomas_jung · Accepted solution]

I don't think you are going to find a direct solution that's going to do all of that for you. Personally I'd deploy the container from the MTAR again and then probably write some of my own scripts to copy the transactional data between the two container instances.

[fabianorosa · Accepted solution]

Thanks Thomas, I'll try to do manually as you suggested.

Regards,

Fabiano Rosa

[azamat_leverx]

https://answers.sap.com/answers/13739498/view.html

[thomas_jung]

From the HANA Cockpit you can export/import an HDI container, but I'm not sure that's exactly what you want either. What are you trying to accomplish here? You can just deploy the same HDI container multiple times if that's what you want.

[fabianorosa]

Hi Thomas,

I'd like to export the data and objects from a "HDI Container A" and import into a "HDI Container B", but using HANA Cockpit the export scripts are generated with the schema name (random as recommended by SAP), but the target HDI Container has a different schema name, so I cannot import using these feature:

Ex: CREATE COLUMN TABLE "C40C89C73DF84D7AA7DB82C7E4E47FD0"."TABLE_A" (...)

As now the source HDI Container has transactional data generated by the application, I cannot just deploy to create a new HDI Container using the HDI Deployer.

Do you have any suggestion for this scenario?

Regards,

Fabiano Rosa

[gregorw]

Hi Fabiano,

when using Import Catalog Objects I see the Option "Rename" for the Schema name:

when you click it you just have to confirm the following dialog:

Please note that my first screenshot was taken after the renaming.

CU
Gregor

[gregorw]

Hi Fabiano,

maybe the recovery service which you can request via an Incident filed for component HAN-CLS-DB could be a way. I've found that at Backup and Recovery for the SAP HANA Service (CF) – by the SAP HANA Academy. Perhaps thomas.jung or rich.heilman can jump in here with an idea.

Best regards
Gregor

[fabianorosa]

Hi Gregor,

Thanks for sharing this guideline, but in my case is more related to rename/migration than backup and recovery of HDI Containers.

Regards,

Fabiano Rosa

[gregorw]

I understood that. My basic idea would be to ask the support to restore into a different Namespace.

[mariusobert]

Hi Fabiano,

is it really necessary to rename the HDI container? Maybe it would be sufficient to re-use the existing container for both apps by adding another service binding.

[fabianorosa]

Hi Marius,

We'd like to rename the HDI Container to apply a naming convention in existent applications in SCP Cloud Foundry, and to avoid rework, we need to rename or migrate the HDI Container content.

Regards,

Fabiano Rosa

[mariusobert]

I see. I'm afraid in this case I don't know what the optimal solution would be 😞

[former_member681897]

Hi Marius,

I have a similar concern, and have started a new thread:

Can you please comment on it:

https://answers.sap.com/questions/13413080/renaming-an-hdi-containerissue-with-hana-analytics.html

I hope posting links like this to request a response is not against the community guidelines.