Migration:- SAP HANA Database copy/move of tenant database

[SAPSupport]

Hi SAP, 

We are Migrating our on-Premise HANA database to Cloud Azure.  Below are more details. 
*********************************************************************************************************************>
On-premises setup: Multi node(3 hosts),Standalone HANA DB with XSA on separate tenant DB.

Nodes: 
node1, node2, node3

Tenant DB’s:
BHP - System DB
BHP – XSA installed
GHP - Client Data

Versions:
HANA:           :2.00.059.1713941539
XSA             :v1.1.3.230717145654
OS              :RHEL7.9

CLOUD Setup: Single Node, Standalone PERSON_NAME DB with XSA on separate tenant DB.

Tenant DB’s:
BHP - System DB
BHP – XSA installed
GHP - Client Data

Versions:
HANA:           :SAP HANA 2 SPS07 Revision 075.00
XSA             :v1.1.8.240122150851
OS              :RHEL9
*********************************************************************************************************************

And, was going through all possible Data migration approach & found below SAP document. On top of this have few questions. 

Copying and Moving Tenant Databases:-

Questions:- (If possible kindly do share SAP document/Note to justify answer)

1. Copy/Paste from Multi Node Source DB to Single Node target HANA, will it support ?

2. Copy/Paste for XSA tenant DB also support ? If yes is there any version dependency, like Target should be same as source or Target should be Higher ?

3. How much time will it take to copy/move 1 TB of DB ? (Approx)

4. After one time copy/move, will it act as real time replication (Apply all changes from source to Target) until we run below command ? ==> ALTER DATABASE <new_database_name> FINALIZE REPLICA

5. Is there any OS dependency or restriction for this Copying and Moving Tenant Databases. 
   Source RHEL 7.9 to Target RHEL 9

Thanks & Regards

------------------------------------------------------------------------------------------------------------------------------------------------
Learn more about the SAP Support user and program here.

[SAPSupport · Accepted solution]

Dear customer,

Thank you for contacting SAP Support.
Please refer to the answers below.

1. Copy/Paste from Multi Node Source DB to Single Node target HANA, will it support ?
A: Yes, it's supported.

2. Copy/Paste for XSA tenant DB also support ? If yes is there any version dependency, like Target should be same as source or Target should be Higher ?
A: Please refer to SAP Note 3445668 - Recommendations Regarding System Copy with SAP HANA XS Advanced. For further support, you may open a separate case with BC-XS-RT component.

3. How much time will it take to copy/move 1 TB of DB ? (Approx)
A: As you may have guessed, it's not possible to provide you the expected elapse time for this operation as it depends on the network bandwidth.

4. After one time copy/move, will it act as real time replication (Apply all changes from source to Target) until we run below command ? ==> ALTER DATABASE <new_database_name> FINALIZE REPLICA
A: Yes, right. 
So, you have to run that command 'ALTER DATABASE <new_database_name> FINALIZE REPLICA'.
Please be informed that the it is impossible to login before manually run the finalize sql.

5. Is there any OS dependency or restriction for this Copying and Moving Tenant Databases. 
   Source RHEL 7.9 to Target RHEL 9
A: With that environment, it's fine because these OS versions are all supported with the respective HANA versions. Please take a look at KBA 2235581 - SAP HANA: Supported Operating Systems

Best regards,
SAP Support