We have a plan to refresh one of our partial copy sandbox. we would like to set up all data as it is post refresh as there any many UAT data in sandbox. I searched and found Template based refresh but that is not an option as business only want same UAT data to be set up back as it was before refresh.
We have 5 GB of data and only one partial copy of sandbox.
I have left with few options-
- Take exports of all data ( around 25 objects) which have many master details and lookup relationship. Manually apply VLookup with new ids from sandbox and insert it back.
- We have Auto Rabit available with us but its also needed source and destination while doing export of data that is also not possible as source will not be there.
Can anyone please help me is there any other way apart from option 1.