We recently purchased a partial data sandbox for a client and it works as expect which is great. One issue thats come up is that the client i actively updating data in production while we work on updates in the sandbox and ideally we could do a refresh of just the records and not destroy the updated visualforce and apex code.
Similiarly one of the things we like most about the partial data sandbox is that we can bring over some data but not others. But what happens is we are building out quite a lot of test data that we'd love to persist between refreshes.
So a couple of questions
- Is a records only refresh possible? Leaving apex/visualforce development alone
- Similarly is it possible to refresh the data but but for any object not included in the refresh template leave any test data built up as is?
for #1 the best we've come up with is to push the development into another sandbox just before the refresh, then push it back. Not ideal but works, #2 sadly we havent found an option other than manual export/imports
Best Answer
If you are using the Partial Data sandbox as your only sandbox environment, I think you will always have this problem. A sandbox "refresh" is really a brand-new instance based on production or another sandbox, and the old sandbox instance by the same name goes into a delete queue. The only way to transfer something from the old sandbox to the new is to export it and import it again, as you note.
As an alternative, I suggest using multiple sandboxes for your process. Do your development in a basic Developer or Developer Pro sandbox (or more than one), and then push development to the Partial Data sandbox for staging and testing before the final push to production. In this way, you can easily refresh the staging sandbox data, and it doesn't have any effect on the main development area. Test data and code you are using in the dev sandbox doesn't need to move.
This method does require a little more routine code management, including timing around refreshes and code releases. And it means you won't have production data inside your primary dev environment without an export/import. However, it's pretty nice to be able to refresh the staging sandbox without disrupting development work.