How to improve replication in sap system during system refresh

[SAPSupport]

Hi Team, Greetings!We are planning to refresh our satellite or source systems CAG(AFS), CBG(BW), CRG(RET)Post refresh, we will be replicating data from these source systems to PERSON_NAME Cloud.AFS- 286 tables to be replicated >> this will take 3 days.BW - 45 tables to be replicated >> Not more than half day.RET - 452 tables to be replicated >> This will take 5 days.Currently we have another project coming and we have a tight schedule and need to ensure all these replication finishes as soon as possible.Previously we were following below approach:Start with replication of AFS first, once done, deactivate the config and then start with replication of RET.When we performed replication for AFS and RET in parallel, we observed that it took more time.Could you let us know what would be the best approach to get these replications completed sooner.

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

[SAPSupport · Accepted solution]

To optimize the replication process and ensure it finishes as soon as possible, you can consider the following approach:

Parallel Replication with Resource Management

1. Resource Allocation:

   • AFS: Allocate sufficient resources to handle the replication of 286 tables. Since this takes 3 days, ensure that the system can handle the load without significant performance degradation.
   • BW: Since BW has only 45 tables and takes less than half a day, you can allocate minimal resources to this process. It can be done in parallel with other replications without much impact.
   • RET: Allocate resources to handle the replication of 452 tables. This process takes 5 days, so ensure that the system can manage this load effectively.

2. Staggered Start Times:

   • Day 1: Start the replication of AFS and BW simultaneously. Since BW takes less than half a day, it will complete quickly, freeing up resources.
   • Day 2: Continue with AFS replication. Once BW is completed, start the replication of RET. This way, RET can utilize the resources freed up by BW.
   • Day 3: Continue with AFS and RET replication.
   • Day 4: AFS replication should be completed. Now, RET can utilize all the resources previously allocated to AFS.
   • Day 5: Continue with RET replication.
   • Day 6: RET replication should be completed.