Overview
The objective of this blog series is to share the experience of migration test from SAP HANA On-Premise to SAP HANA Cloud. In Part 1, I have converted classical Calculation Views to XSA based HDI Container model. In this blog i will migrate the model from SAP HANA On-Premise to SAP HANA Cloud.
Please note that SAP has plan to release migration tool (the planned first scope is from SAP Cloud Platform, HANA Service (HANA as a Service / HaaS) to SAP HANA Cloud), this means probably the steps described in this blog will be obsolete in the future.
Let’s get started. We will proceed in the following steps.
1. Access to SAP HANA Cloud
2. Import and Build the model
1. Access to SAP HANA Cloud
1.1 Access to SAP HANA Cloud with SAP Web IDE for full-stack
Open SAP Web IDE for full-stack and go to “Global Preferences > Workspace Preferences > Cloud Foundry”, and then configure API Endpoint, Organization and Space of SAP HANA Cloud.
1.2 Create a project
At “Development” tab, right-click on the “workspace” and create a new project from template.
Choose “Cloud Foundry” for Environment and select “SAP HANA Database Application”.
Enter project name and create project.
Project “SALES” has been created.
2. Import and Build the model
2.1 Export source files
Export source files from On-Premise SAP HANA. The file is exported as a ZIP file.
2.2 Import the source file
Import the ZIP file into SAP HANA Cloud. Right-click on the “src” folder under “Sales” project and import file.
Files are imported successfully. Delete “.hdbgrants” file because it is not used anymore.
Adjust the schema name of “.hdbsynonym” file if needed.
You can confirm the Calculation Views are successfully imported.
2.3 Build the source files
Build the source files.
Check that Build process is completed successfully. You can confirm that Calculation Views are created and accessible from Database Explorer. Output is 0 record because no data has been migrated at this point.
We have successfully migrated tables and Calculation Views from On-Premise SAP HANA to SAP HANA Cloud.
No comments:
Post a Comment