Schema conversion after HANA refresh

[Former Member]

How to convert the schema after performing HANA DB Refresh ?

In general terms how to preform the schema conversion in HANA DB ?

[Former Member]

This message was moderated.

[Former Member]

Hi

Let me be more specific.

I have performed the System copy as per the note 1844468 - Homogeneous system copy on SAP HANA

1. Schema name in QAS is SAPQAS

2. Schmea name in PRD is SAPPRD

Now, I have performed the copy as per the above mentioned Note.

Before Copy: Schema name in QAS is SAPQAS.

After Copy: Schema name in QAS is SAPPRD.

Now, I want to convert the new SAPPRD schema that is present in QAS to SAPQAS.

This is same like schema conversion in MSSQL & ORACLE DB after copy.

[AtulKumarJain]

Hi Pavan,

I would like to update you ,why you required change the name of your schema??

I don't thing it is required after system copy in HANA , Is there any specific requirement for this.

@ Lars Breddemann Prabhith Prabhakaran you can put your view as well , As Pavan need update from you.

Please explain the purpose for this.

Best Regards,

Atul

[Reagan]

>>Now, I want to convert the new SAPPRD schema that is present in QAS to SAPQAS.<<

This is possible if you do schema export and import with the rename schema option from the HANA studio. Else you will need to do the system copy using R3load based export/import and not using backup and restore option of sapinst.

[erent_devos]

Hi Lars,

We have the same Issue. Strange the sapinst procedure is asking you're schema details (TARGET and SOURCE) but not converting to Original schema name of the target.

Like you should the same schema name for your different systems.

Can you share what option you took to put to original state ?

Thx

Erent

[Former Member]

HI Erent,

Schema conversion is not required in SAP HANA refresh.

Regards,

Pavan Gunda

[former_member182967]

Hello Pavan,

Refer to the link below:

As Tomas said, you can't change HANA schema name.

Regards,

Ning Tong

[Prabhith]

HI ,

As Lars rightly told, your question is not clear enough.

I know something called Schema mapping which is done when the physical schema in the target system is not the same as the physical

Creating a mapping in the Target system between the Authoring schema and Physical schema but I believe that is not what you are looking forward, isn't it?

BR

Prabhith

[AtulKumarJain]

Hi Pavan,

Please check the  system copy/refresh guide for HANA.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/90530553-b686-3110-498b-e1dab0282...

As per the guide

Enter the schema names and the passwords that match the data in the backup. For example, if you install a system DEV and use a backup of the system PRD for the installation, you must specify SAPPRD as the schema in the dialogs, not SAPDEV

So why you required the Schema change.

Please also check below sap note

1775293 - Migration or system copy to SAP HANA using the latest software provisioning manager (SWPM ...

BR

AKJ

[lbreddemann]

No idea what your questions even mean.

What do you mean by "HANA DB refresh"?

What kind of schema conversion do you want to do? What for?

- Lars