how does Upgrade works for HANA as a service on Neo to HANA as a service on CF

[ssurampally]

Hi, I understand that, Initially SAP HANA as a service available in Neo Environment of SCP, 1.0 SP12 is the last version of HANA in there. The next and latest releases of HANA 2.0 are available in Cloud foundry environment of SCP and it is based on cloud foundry run-time(which is similar to XS advanced run-time in on-premise). so with that, all the application development of HANA 2.0 service will be performed using Web IDE full stack.

I believe, we can't use HANA studio or Eclipse for HANA 2.0 object developments right? it has to be only Web IDE full stack?

I am wondering, how does upgrade happen if we wish to switch from HANA 1.0 service(with xs classic server) to HANA 2.0 service (with cf run-time)?

Thanks

Sreekanth

[former_member187069]

Hi Sreekanth,

I am trying to migrate HANA from Neo to SAP HANA Cloud on CF. My tables are all created using HANA SQL and the calculation views are script based. I have a few clarifications here on the migration approach :

1. Will the XS Migration Assistant tool help in migration of DB? as suggested in SAP HANA XS Advanced Migration Guide. ( We have converted the scripted calculation views to graphical CVs with the help of the view-migration tool in SAP HANA Modeler. Our old HANA version is SAP HANA SPS 12. ) For the final step of deploying the migrated application to XS Advanced - we need to do it in Web IDE right? Or we should use BAS here?

2. If the tool doesnt help, should we manually create tables and calculation views in BAS? Or can it be done in Web IDE? Because we have lot of CVs to be migrated. Is there any way where we can import the CVs into BAS or Web IDE?

Thanks

Vishnupriya

[ssurampally]

1. Development tool, you can choose either Web IDE or BAS while working on HANA cloud CF., it is your choice, Web IDE has been there for a long time and BAS is new and will be having all new innovations.

2. All design time artifacts will be converted with tool, if there are any objects which are created directly in run time, like CREATE TABLE, VIEW ad PROCEDURE then you will have to manually create them in Web IDE or BAS projects.

[former_member608991]

Hello Sreekanth,

Planning to migrate from HANA Cloud (on Neo) to HANA Cloud (on Foundry).

Is it mandatory to also migrate SAC on Neo to SAC on Cloud Foundry ?

Is the effort the same, in the sense that if the DB is migrated, SAC's platform will automatically changed from Neo to CF, or is the effort separate to migrate SAC from Neo to Cloud ?

Thanks

Pradeep

[johannes_scheerer · Accepted solution]

Hi Sreekanth,

you are correct in that the migration from HANA 1.0 in neo to HANA 2.0 in the cloud foundry environment means also moving the content between two systems. In case you use the XS Classic design time to create database artefacts, e.g. tables, you can reference this blog for a guide how to do so.

For manually creating database artefacts and general administration, SAP HANA Cockpit is the recommended tool for HANA 2.0. You can launch it directly from the Cloud Cockpit of SAP Cloud Platform.

Web IDE full stack is the recommended tool for creation of design time database artefacts for HANA 2.0.

It stays your choice whether you want to go for manually creating database artefacts or if you want to go for design time artefacts and automatic creation during deployment.

For the migration of the data, you may take a look at the SAP HANA XS Advanced Migration Guide.

Best regards,

Johannes.

[ssurampally · Accepted solution]

Perfect, thanks Johannes. It is the same approach as on-premise one, but in on-premise it is optional to have XS advanced server though we are upgrading to HANA 2.0, I mean we can still continue to use XS classic. Does it applicable in cloud? I mean can I just get the database version to HANA 2.0 service with out actually using cloud foundry run-time? So that I can continue to use HANA studio/Eclipse with xs classic capabilities., I know it is not recommended as you said already and we don't get real the benefits of 2.0 cf run time, but I just wanted to know the possibility of separating the data base upgrade and getting to cf run-time in 2 phases., please let me know your comments.

[ssurampally · Accepted solution]

Hi, johannes.scheerer ., Can you please confirm that my understanding in the comments is correct?

[svenkohlhaas]

Hi Sreekanth,

at this point in time if you are using the SAP HANA service in the Neo environment of SAP Cloud Platform, then only SAP HANA 1.0 is available. If you are using the SAP HANA service in the Cloud Foundry environment of SAP Cloud Platform, then only SAP HANA 2.0 is available. Therefore, if you want to use SAP HANA 2.0, you need to use/migrate to the Cloud Foundry environment.

How such a migration would look like you might see e.g. in this blog post.

All the best,

Sven

[ssurampally]

Thank you Sven, I have gone through the blog provided by you, but in that use case HANA DB tables were getting created by application layer(Java or nodejs). However, in my use case, DB tables are directly created using HANA SQL, similarly DB views, Stored procedures and functions etc., also we have got several information models(Calculation views) created for analytical purpose in HANA 1.0 system. now, if we wanted to get HANA 2.0 on Cloud foundry, we will get a brand new HANA instance right? with that, I am assuming that, I will need to create all DB tables and Views again in the new HANA instance manually. Now my question here is, would I be able to use HANA studio for HANA 2.0 and import the content of HANA 1.0? or Should I only be using Web IDE full stack and develop all the objects as design time artifacts in HDI containers.

[kavya_kathuria]

Hi all! is there a better way to do this now that Neo also has HANA 2.0? I'm currently looking at migration options for the same!