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: 
VolkerSaggau
Product and Topic Expert
Product and Topic Expert
1,937

 Problem:

NEO or HANA 2 XSC database content as tables, views, calculation views, etc. needed to be migrate to SAP Business Application Studio or BUILD Code for further development. 

 Requirements:

  1.   A SAP Cloud Connector for your HANA 2 environment 

  2.  A BTP account with SAP Business Application Studio (BAS) or SAP BUILD Code entitled

Solution:

Convert DB content from XSC/sys_repo into HDI/CAP content using SAP Application Migration Assistant. 

 Preparation:

  • In BTP: Configure your DevSpace as mentioned below 

  • In BTP: Configure the use of SAP Cloud Connector 

It should look similar to this screenshot: 

 

VolkerSaggau_0-1722514249841.png

 

Find more help on this in the cloud connector help and in this blog: 

Connect SAP HANA On-Premise to SAP HANA Cloud and Database with Cloud Connector 

  • Add the following extensions to your development space of BAS: 

 

VolkerSaggau_1-1722514284204.png

 

SAP HANA Application Migrations Assistant will help you migrate content 

SAP HANA XS Advanced Tools will allow to work with BAS on your XSA environment 

  1. SAP HANA XS Advanced Tools allows you to connect and deploy to XSA environment for HANA on premise 

  2. SAP HANA Application Migration Assistant will migrate content from XSC/sys_repo to an HDI project.  

Calling the SAP HANA Application Migration Assistant by  F1 :"SAP HANA Application..."

 

VolkerSaggau_2-1722514328164.png

 

 

Sample of conversion from XSC to CAP: 

Original design time object in HANA Studio: 


VolkerSaggau_3-1722514450026.png

 

Here is the result of a conversion to CAP CDS: 

 

VolkerSaggau_4-1722514499037.png

Once you are in BAS you can also see the HANA Cloud generated code here as well: 

VolkerSaggau_5-1722514539520.png

There are many functions and features build in to this tool. Please try out and read the help manual.

Summary:

At this moment the tool converts XSC design time objects of the database to an HDI / CAP level. Not all objects can be migrated since there is no equivalent in HANA Cloud /CAP. Anyhow this helps to get a huge amount done supported by the generator/converter. With the change of xsjs to Node.js we decided to use the CAP model. This helps developers to also get the ODATA access being generated as well. And with BAS and/or BuildCode it should be be possible for many use cases to get into the BTP world with all modern features as the latest Fiori and Joule support. 

This will also help you to get to the environment where you also can develop for "Clean Core". So you end with this migration at the same dev environment. 

Also many thanks to the great support from the CAP team. 

Outlook:

Several things are in the pipeline: 

  1.  XSA -> SAP HANA Cloud and CAP
  2.  Data migration
    1.  This is a bit more complicated: We have to rename the objects to be CAP compliant. So the source and the traget name differ. We provide a list of the name changes and we will use this to generate SQL commands for data copy purpose.

 Links:

SAP HANA Application Migration Assistant (This tool)

The old migration tool that is replaced by this tool

Cloud Connector installation

SAP HANA Cloud Migration Guide

Sample on GitHUB

Connect SAP HANA On-Premise to SAP HANA Cloud and Database with Cloud Connector

 

more help is on its way (will be added later)

 

 

2 Comments
AlexandruManole
Associate
Associate

Is the migration path from XSA to CAP on the roadmap?

JayeDutton
Discoverer
0 Kudos

I have been using the migration assistant and it is very hit and miss. It (sometimes) works for small simple packages / delivery units but it struggles with real life example (Gets stuck on XS Migration: Starting Processing).

JayeDutton_1-1725431348751.png

And has only read the objects in and seems to time out:

JayeDutton_0-1725431332334.png

Is there a VS Code add-on so i can run it locally?