Question Re: Hana Cloud data refresh in Technology Q&A

Hana Cloud data refresh

FabienHenique — Fri, 31 Mar 2023 16:23:34 GMT

Hello,

We do have an Hana Cloud DB on BTP and I would like to refresh test instance with production one.

Do you know how to deal with this?

Thanks!

Re: Hana Cloud data refresh

AlexPJ — Mon, 03 Apr 2023 07:23:08 GMT

Hello Fabian,

SAP HANA Cloud does not support copying the complete HANA database using backup & restore, yet.

If you use HDI container, you can export an HDI container to a cloud storage from your production instance and and import it again to your test instance. This worked well for us with an HDI container of about 25GB. Not sure how it works if the HDI container is much bigger.
If you are fine with copying specific tables only, you can utilize SDA to copy these tables from production to the test instance.

Best regards,

Alexander

Re: Hana Cloud data refresh

FabienHenique — Tue, 04 Apr 2023 14:56:24 GMT

Thanks for your help, I've been able to perform this data refresh with SDA.