Technology Blogs by SAP
Learn how to extend and personalize SAP applications. Follow the SAP technology blog for insights into SAP BTP, ABAP, SAP Analytics Cloud, SAP HANA, and more.
cancel
Showing results for 
Search instead for 
Did you mean: 
apoorva_nagaraju
Product and Topic Expert
Product and Topic Expert
2,104

SAP provides a tool called Self-Service Migration to assist migration to SAP HANA Cloud.

This tool checks the compatibility of your SAP HANA database with SAP HANA Cloud and identifies which features, database objects, and SQL statements can be migrated seamlessly, and which need to be adapted before use.

Self-Service Migration tool also includes information about the features that cannot be automatically migrated and offers suggestions about how to adapt your current implementation to work in SAP HANA Cloud where possible.

Pre-requisites

  • Supported for SAP HANA Database Revision 53 or greater.
  • Connectivity Service Entitlement with the service plan “connectivity_proxy” must be enabled for your subaccount using the SAP BTP cockpit.
  • Create the migration user in the source HANA database and assign necessary privileges.
  • Establish a connection to the source database using Cloud Connector.

Procedure

1. Open SAP HANA Cloud Central, navigate to “Migrations”.

apoorva_nagaraju_6-1711957784886.png

2. Choose “Create Migration”, specify the migration information, and then “Create”.

apoorva_nagaraju_7-1711957819088.png

3. In the PLAN phase,

a. Select the source database system that you want to migrate.

Enter the virtual host and port that you specified in the cloud connector configuration.

b. Specify the cloud connector details.

Enable Cloud Connector and specify the Cloud Connector Location ID.

c. Enter the credentials of the migration user that was created in the tenant database of the source system.

d. Check Compatibility with SAP HANA Cloud.

apoorva_nagaraju_8-1711957874277.pnge. Once the Self-Service Migration tool finishes checking your database, it lists any incompatibilities found. The list is grouped by Database Objects and SQL Statements.

f. It provides information on the compatibility of the database objects and executed statements with SAP HANA Cloud.

g. Only checks with the severity 'CRITICAL' and 'UNKNOWN' will forbid the migration. Checks with the severity 'ERROR' or below will allow the migration; however, it is possible that some functionality may not work as expected in the target database.

h. Review and resolve the incompatibilities where possible. Choose Proceed to Preparation Phase.

apoorva_nagaraju_9-1711957939343.png

4. In the PREPARATION phase, you specify what to migrate, where to migrate it to, and which user credentials are required to perform the migration. (XS advanced service instances is not included in this migration)

a. Specify the credentials of the migration user and choose “Save and Proceed to Select Target”.

apoorva_nagaraju_10-1711957976362.png

b. Choose the target database for the migration. Enter the credentials of the DBADMIN user on the target database and “Proceed to Execution Phase”.

apoorva_nagaraju_11-1711958003384.png

5. In the EXECUTION phase, choose “Start Migration” to trigger the migration process and monitor progress in the status bars.

apoorva_nagaraju_12-1711958034773.png

After the migration, a summary is displayed, and you can proceed to the VALIDATION phase.

apoorva_nagaraju_14-1711958065255.png

6. In the VALIDATION phase, the metadata and data of the migrated content are checked for consistency, also the record count of the tables to be migrated can be checked.

Choose “Proceed to Finalization Phase”.

apoorva_nagaraju_15-1711958095512.png

7. In the FINALIZATION phase, the finalization process removes all artifacts that were temporarily stored by the migration service.

a. Choose “Deactivate migration user” to disable the DMUSER after the migration in the target SAP HANA database and “Finalize Migration” to complete the migration and start the post-migration clean-up.

apoorva_nagaraju_16-1711958126138.png

b. The SAP HANA database is migrated to SAP HANA Cloud. A summary screen is displayed, containing information about the completed migration, including statistics about the migrated database, migration step durations, and validation statuses.

apoorva_nagaraju_17-1711958151384.png

c. “Clean Up Process” will archive the completed migration. Once the migration is archived, it serves as a reference and cannot be altered. Up to 20 migrations can be archived.

apoorva_nagaraju_18-1711958187260.png

Conclusion

In this blog, we have learnt on how to migration SAP Hana On-Premise to SAP HANA Cloud using Self Service Tool.

In the next blog will look into on how to migrate the XS advanced service instances from on-premise to SAP BTP.

XSA Service Instances Migration from On-premise to Cloud Foundry