Migrating an SAP HANA On-Premises Platform

Objectives

After completing this lesson, you will be able to:

  • Perform a migration from SAP HANA On-Premises Platform to SAP HANA Cloud

Migration Landscape Overview

In this lesson we are going to show you how to perform a migration from an on-premises SAP HANA database to an SAP HANA Cloud database instance using the Self-Service Migration for SAP HANA Cloud.

The image shows the landscape used for the migration.

The image shows an overview of the on-premises to SAP HANA Cloud landscape with all the important input data need by self-service migration tool.
Note
For the SAP HANA on-premises scenario, you require the connectivity_proxy service plan to be added to the connectivity service in your subaccount entitlements.

During the migration the self-service migration tool requires some input before the actual migration run can start. The self-service migration tool requires the following input:

  • Migration Name - Give a short descriptive migration project name.

    We will use: Migration OP to HC.

  • Migration Description - Give a good description for the migration project.

    We will use: Self-Service Migration SAP HANA on-premises to SAP HANA Cloud​.

  • Source Instance Host - This is the virtual host name exposed to the SAP BTP through the Cloud Connector.

    We will use: op-source-hana. The real host name wdflbmt7346 isn't exposed to the SAP BTP.

  • Source Instance Port - This is the virtual port number exposed to the SAP BTP through the Cloud Connector.

    We will use: 42015. The real port number 30015 isn't exposed to the SAP BTP.

  • Cloud Connector Location ID - This is the location ID defined in the Cloud Connector.

    We will use: SCC-OP-HANA.

  • Migration Username - This is the dedicated migration user account created on the source database during the preparations steps.

    We will use: MIGUSER.

  • Migration Username Password - This is the password you specified during the creation of the migration user.

    We will use: Welcome1

    Note
    Please note that Welcome1 is NOT a strong password and shouldn't be used during a real migration.
  • Target database Username - This is the database administrator user name created during the SAP HANA Cloud database deployment.

    We will use: DBADMIN.

  • Target Username Password - This is the password you specified during the deployment of the SAP HANA Cloud database.

    We will use: Welcome1

    Note
    Please note that Welcome1 is NOT a strong password and shouldn't be used during a real migration.

Demonstration: Using the Self-Service Migration Tool to Migrate an On-premises SAP HANA to SAP HANA Cloud

The demonstration shows migration from an on-premises SAP HANA database to an SAP HANA Cloud, SAP HANA database on SAP BTP.

Summary

In this lesson, you learned how to use the Self-Service Migration for SAP HANA Cloud tool to migrate an on-premises SAP HANA database to SAP HANA Cloud.

Further Reading

Log in to track your progress & complete quizzes