[HANA CLOUD] How to back up a schema from PRD and import it to QAS

[minhpht294]

Currently, I am learning and researching about BTP and Hana Cloud for my next project.

I have few questions:

1. Imaging that I have created Hana DB in BTP and split it into Dev 20GB, QAS 30GB and PRD 50GB. Every 6 months, I need to copy some Schema / Table Data from PRD to QAS to make sure our QAS can use the up to date data for training and developing. Which tools or Technique should I use for this situation?
I am thinking I can do it such as S4 On-premise by using some LSMW tools, program or take DB Snapshot for this situation but I can't find out any information about it.

2. After running many years, the data in PRD will become bigger and it needs to be archived. How can I compress all the data need to be archived and Where should I store it? 
I am thinking about using Data lake but not really sure about it.

Please help.

[RobertWaywell · Accepted solution]

With regards to archiving or tiering data, what is your expected data volume and what is the expected growth year over year? 

The first option for data tiering is to keep all of the data in HANA and take advantage of HANA's Native Storage Extension to tier data to disk. This can be done at a table partition level. Architecturally using NSE is the simplest approach as it keeps all of the data in the original tables, which in turn means that the application developers don't have to worry about querying separate tables when "old" data is required. NSE is invisible to the application layer. 

[minhpht294 · Accepted solution]

Thank you for replying, I am a newbie in cloud so I am very appreciated.
I am looking for the NSE document for further knowledge. 

"With regards to archiving or tiering data, what is your expected data volume and what is the expected growth year over year? "
-> I am not really sure about it. So, the amount of data increasing each year will affect the technology used to store data, am I understanding that right? So if each year the data increases by 50 ~ 100 GB, what will it be like?

[RobertWaywell · Accepted solution]

A growth rate of 50 - 100 GB per year would be considered relatively small. A HANA Cloud, HANA database using NSE can readily support up to at least 10 TB of data and for a pure archiving use case then you can scale beyond that.

[minhpht294 · Accepted solution]

Thank you very much. I am clear with the Archive Data by using NSE. But how about the first question, I still looking for some solution about it? Maybe the Table Replicate will be a good solution?