Backup and Restore
For backup and restore we use the HANA Web Interface at the path /sap/hana/ide/catalog/.
Open the Catalog and locate the SITREG schema. Right click on the schema name and choose Export from the context menu. In the pop-up choose Binary (When your target HANA System has the same Version. Otherwise choose CSV) for the Column Table Format. Then click OK to save the zip file to your local computer.
If you have an existing copy of SITREG in your HANA system, then remove the SITREG schema first the catalog. You do that by a right click on the schema, choose delete, switch to Cascade in the pop-up and click OK.
Also delete the package sitreg below the package com/sap/sapmentors using the SAP HANA Web-based Development Workbench at path /sap/hana/ide/editor/. You have to choose Force Delete from the context menu.
Right click on the catalog and choose import from the context menu. Click on the upload icon and choose the ZIP file you've downloaded during the backup. Click the >> icon to choose all objects for import. Confirm with OK.
You will see the Job Log that shows the status of the import process:
After the import is finished open the SAP HANA User management at /sap/hana/ide/security/ open the user _SYS_REPO, switch to the tab Object Privileges, add the SITREG schema, tick the ALL checkbox and choose Grantable to Others Yes:
This is required to allow activation of the repository objects in the SAP HANA Web-based Development Workbench.