on 2024 Oct 03 9:35 AM
Hello experts
i have a backup file of a database of a particular SAP BTP trial account now i wants to restore this database over Sap Hana cloud instance in a new SAP BTP trial account .
i have explored Sap community to find solution and guidance .
in that journey i got some articles and tutorials.
This tutorial help us to clone SAP HANA database instance via template based cloning.
but this guidance only helps me to clone SAP HANA database instance within same trial account .
This guidance material helps me to import catalog objects in HDI container.
again ,this solution is limited within single trial account because we can only import and export SAP HDI(Hana deployment infrastructure) Container for copy purposes within single trial account.
Both tutorial covers cloning Hana cloud instance and importing and exporting HDI container but both are limited within single SAP BTP trial account and i wants to restore Database over sap Hana cloud instance using database back up file of different trial account.
@thomas_jung @qmacro , @MioYasutake ,@gregorw, please help me How to restore database over SAP HANA cloud instance using backup file of a database.
Thanks @AlexPJ @RobertWaywell for your reply , i have followed this article for exporting Hana HDI container for copy purposes
CREATE COLUMN TABLE <MySchema>.EXPORT_TABLE LIKE _SYS_DI.TT_CONTAINER_EXPORT;
GRANT INSERT, SELECT ON <MySchema>.EXPORT_TABLE TO C1#DI;
CALL _SYS_DI#G.EXPORT_CONTAINER_FOR_COPY
('C1', <MySchema>, 'EXPORT_TABLE', _SYS_DI.T_NO_PARAMETERS, ?, ?, ?);
EXPORT <MySchema>.EXPORT_TABLE AS BINARY INTO '<export_path>'
WITH REPLACE NO DEPENDENCIES;
as per article ,this SQL code exports HDI container. I am using using sap BTP trail account ,in this environment what should be value of '<export_path>' .
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You followed documentation that is for HANA Platform, i.e. for HANA on-premise instances. This won't work with HANA Cloud.
Use the documentation for HANA Cloud, HANA databases instead, for instance Importing and Exporting with Amazon Web Services | SAP Help Portal or Export an SAP HDI Container for Copy Purposes to a Cloud Store
User | Count |
---|---|
72 | |
11 | |
10 | |
7 | |
7 | |
7 | |
7 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.