There is a bit of information around which discusses backing up Salesforce using the data export capabilities or one of the data loader tools to download SF data into text files or ar relational database.
What isn't often mentioned is how to restore this data.
Because Salesforce does not permit you to dictate the ID of the record you are inserting, any moderately complicated data model which has inter-relationships between objects poses a difficulty as you won't be able to maintain these relationships.
I have done it by using external Id fields, but this means my data model really needs to have fields in it to support a data restore, not something I see mentioned in any documentation.
So my questions are thus:
- Can the ID field be dictated in a data upload if this is requested from support?
- If it can't, how do people handle resolving these relationships?
- What tools exist which elegantly and simply solve this problem?