Restore a Schema under Different Name

[Former Member]

Hi HANA Experts,

I am using Business One version for HANA, Studio Service Pack SP5.

Can anyone guide how to restore Schema with  a different name in HANA Server using HANA Studio.

Scenario: I have a Schema "A" and I would want  to  backup and restore Schema "A" as Schema "B" without Schema "A" being replaced.

Thank you for your time.

Best Regards

[Former Member]

Or you can use the EXPORT command to export the objects.

Then edit them in the command line to change the schema name.

Then IMPORT on the target system.

John

[Former Member]

Thank you for your valuable input.

[Former Member]

Hi Uma,

You cannot restore schema as different name for SP05, not support on SP05, but you can use import command to change schema to meet your request based on SP06 on HANA server side, does not support SAP HANA studio on SP06.

Hope this can help you.

Regards,

Jerry

[Former Member]

Hi Jerry,

Thanks for your reply!

Can I understand like In HANA Studio it is still  not possible to restore the schema under different name in the version SPS06.

Please advise on the steps as how it can be done at the HANA Server level. Thank you

Regards

Uma

[Former Member]

Hi Uma,

Yes, correct.

Please refer to below thread, it has syntax for import and rename schema.

http://scn.sap.com/thread/3409793

Hope this can help you.

Regards,

Jerry

[Former Member]

Hi Jerry,

Thank you for the helpful reply. As of now I am having HANA Studio version of SPS05 as mentioned earlier. How easy is to upgrade to SPS06. Is there any precautions or pain points to be taken care. Can you advise please.,

Regards

Uma

[Former Member]

Hi Uma,

You can use HLM or SUM to upgrade your HANA server via HANA studio or command.

Please refer to below thread.

http://scn.sap.com/community/distinguished-engineers/blog/2013/05/29/which-tool-to-use-for-sap-hana-...

Hope this can help you.

Regards,

Jerry