Hana system client copy

[Former Member]

We have an ECC QA with 2 clients (100 and 200) on Hana.

We have a question about its client copy from PRD/100->QA/100.

For the client copy target on SQLserver, we use the folowing way

to avoid the notorious slowness to delete target data at the

beginning of the copy:

1) copy all tables that have QA/200 data to another empty DB on the

same SQLserver;

2) truncate all tables on QA -- this is very fast;

3) copy the QA/200 data back to QA which now has noly QA/200 data;

4) do client copy from PRD/100->QA/100.

We want to use the same way to Hana based QA systems.

However, we do not have SAP HANA multitenant database containers

therefore we do not know how to the first step on Hana:

-- copy all tables that have QA/200 data to another empty DB on the

same Hana.

So we think about following possibilities:

1) export QA/200 to a flat file and import after the client-copy is done

or

2) try to build SAP HANA multitenant database containers

or

3) use SLT or DS from a dedicated copy of QA/200 (but this is even slower?)

Your recommendation is extremely appreciated.

[Former Member · Accepted solution]

Hi Christina,

I have't performed the above task . But , below is only my opinion.

Option:1. I feel that it is better option & easy way to do it.

Option:2. Little bit more lengthy process and time consuming process

Option:3. obviously, it is very slow.

Regards,

Pavan Gunda

[abhishek_singh11]

Hi Christina,

According to the Note 1661202 - Support for multiple applications on SAP HANA in SP09, it is now supported to use the HANA concept of Multitenant Database Containers (MDC) and run two SAP systems, e.g. an ERP and a ECC-HR on the same Hana Appliance, but each SAP system having it's very own Tenant DB - in Production !

I believe first option is good for a copy from HANA.

Thanks Much,

Abhishek