We have a developer sandbox which is refreshed quite frequently. There are some some seed objects that need to have data so that the sandbox becomes usable. I am trying to develop a script which will automate this thing i.e. will copy data from production to sandbox for these objects. I used the command line data loader by salesforce.
-> Got stuck where i need to copy "Sales Coach" object & the child object - "Sales Coach Line Items". While loading the Sales Coach Line Items the Sales Coach lookup ids point to production but i need the ids of the sandbox. Is there way to solve this problem?
-> Also i need to migrate some attachment object records. Is this possible with CLI?
Is there any other tool or other approach that can be used to achieve the above?