Chris Horne - 6 years ago
Agree with Bill Riemers- there needs to be some way to specify what data will be copied into the partial database. Even if just a blanket statement to say the first 10,000 newest records, oldest, or whatever. Even better would be some kind of SOQL query or just a report to help narrow down the rows.
Alternatively, the records that relied on Hierarchical data could be processed first. For example, we have a custom object that relies on both a Contact and an Account record. None of the data for this custom object gets copied currently becuase only old Contacts and Accounts are moved over. If the system would scan dependencies and run the items with dependencies first, this would certainly be better than just skipping them.
Bill Riemers - 7 years ago
The selection of data should not be random. Salesforce should have a way to tag what data you want copied. I might find a partial sandbox very useful even with 10,000 records per object type, if I could make sure they were the 10,000 records I needed most. But selecting random, means a majority of the data will be what would be considered stale data. e.g. Close Lost opportunities, inactive pricebook entries, accounts that haven't been used in years, ...