How to set HANA as the DB for HANA Cloud?

[js2]

Hi, I setup my NW Cloud account long before HANA was available as a db. Now that it is.... How do I switch over to make HANA the db? I've read that you have to specify the db you want to use when you create your account but this doesn't help if you already have an account.

Regards... Jason.

[former_member197208 · Accepted solution]

Hi Jason,

unfortunately changing the DB type is not yet possible automatically.

Let us know if you want your account switched to HANA.

There are some limitations though:

* Any existing DB Users/Schemas will not be changed!

* Persistence of existing applications will stay on the same DB server, there is no migration.

* If an application/component name has been used in the past, a DB User/Schema already exists, even if the application has since been undeployed again. If a new application with the same application/component name is deployed the old DB User/Schema /using the old DB Type) will be re-attached and re-used.

* Only newly created DB Users/Schemas (for applications with application/component name which has never been used before in this account will use the Default DB Type set with this procedure.

- ab.

[js2 · Accepted solution]

Hi Andreas, if you could change it to make HANA the default that would be great. I don't care about any of the tables/data that is already there as its all just test stuff that can be happily blown away...

😉

Thankyou.

[former_member221863 · Accepted solution]

Hi Jason,

Could you please provide me the account name? I will change this and let you know once this done. I will also delete the old schemas from the DB. Please also provide the landscape information.

Regards

Ganesh Vattamwar

[js2 · Accepted solution]

Hi. My username is P1081110. what other information would you need. I'm a devloper so this is for the trial systems not a production landscape.

[former_member221863 · Accepted solution]

Hi,

Account is changed to use HANA DB now. Could you please try and let us know if you have issues?

Regards

Ganesh Vattamwar

[js2 · Accepted solution]

Thankyou

[Former Member · Accepted solution]

Hi,

Can you please also change my SAP HANA cloud default db to HANA DB?

My username is I014511. And I am using the HANA trial account.

Regards,

Channel

[former_member221863 · Accepted solution]

Hi Channel,

You can create multiple accounts on your own and choose the default DB type during creation. The documentation can be found at the following location.

https://help.hana.ondemand.com/help/frameset.htm?65d74d39cb3a4bf8910cd36ec54d2b99.html

Regards

Ganesh Vattamwar

[Former Member · Accepted solution]

Hi,

I just tried to change it, I already have an existing account (so I can't see the "account creation screen").

I tried to register for a new one (I want to use the same email address), but it says: An account already exists with that e-mail. Register another or sign on with the e-mail.

on Account: i014511trial

Regards,

Channel

[former_member221863 · Accepted solution]

Hi Channel,

You cannot change the existing account, rather creating the new one with another mail address should be possible.

If you want to use the same account but with different DB, then the old application name should not be used, in your case 'mailtest'.

After the switch you need to deploy the application with differnt name. please do let us know so that we can go ahead and change this.

Regards

Ganesh Vattamwar

[Former Member · Accepted solution]

Hi,

You can go ahead and change it, I removed all of the applications on there and will just redeploy it.

Regards,

Channel

[former_member221863 · Accepted solution]

Hi,

I changed it, but redeploy with the same application name will again point to the old maxdb schema, so you need to use the different application name.

Regards

Ganesh Vattamwar

[Former Member · Accepted solution]

Hi,

Thank you.

Noted, I will change the name.

Regards,

Channel

[Former Member · Accepted solution]

Hi Ganesh.

Could you please change my default DB to HANA on SAP HANA cloud. I know that I will have to change my application names.

My account name is: i014828trial

Is it possible to connect to the SAP HANA cloud DB (HANA) with SAP HANA studio?

If it is can you provide me with more details or a link?

Regards,

Charl

[former_member221863 · Accepted solution]

Hi Chari,

Let me first answer your second question

Is it possible to connect to the SAP HANA cloud DB (HANA) with SAP HANA studio?

If it is can you provide me with more details or a link?

You can try using the remote DB access, the documentation can be found at the following location

https://help.hana.ondemand.com/help/frameset.htm?b8f084c24064426c8e9a67da62b53bb5.html

I will answer your first question, need some time here.

Regards

Ganesh Vattamwar

[former_member221863 · Accepted solution]

Hi Chari,

I have changed your account i014828trial to use Hana DB as default db now.

Regards

Ganesh Vattamwar

[Former Member · Accepted solution]

Thanks Ganesh.