We have a requirement consisting of periodically synchronising test environment with production environment.
The strategy used is follow the documentation procedure here:
The goal is to automate that. The problem we are facing is that the data coming from prod is huge (which is expected). The backup of production is huge and the composition of the tables make it difficult to do it in once.
Is there a way to fragment or segment the backup from an installation? I know there are several tables and some fields are quite big, I don’t know if there is any advice on how to do this.