Several developers add a lot of features to our production org, so we refresh our sandboxes pretty frequently, wiping our test data. Recreating test data for 10+ objects every other day is becoming repetitively frustrating.
This question was asked in the past and there are a couple duplicates as well. BUT. We are very secure about our data and don't trust any app/tool that is deemed 3rd party (whether or not it is a desktop version or a web version), so the accepted answer is not going to work for us.
Data Loader and Excel connector work one-object-at-a-time, so it is not efficient when dealing with just a few records that belong to a lot of different objects.
So I was wondering if there are other (Apex) ways to read data from Production and insert in a Sandbox (perhaps Web Services?). Fortunately, Salesforce allows us to run ONE class after each refresh, so I was thinking of writing a method that brings 'test data' over.
We will move only a small part of the production data. Maintaining the relationships is not super important, because we are OK with linking them manually as needed at the time of our testing... that is, minimize the effort as much as possible if we can't totally automate it.
Any pointers in the right direction will be awesome. Thank you!