+ Start a Discussion

Best way to move a subset of data from Production to Sandbox?

I'm looking for guidance on the best way to move a subset of data from my Production org to my Development Sandbox.  I already have the meta-data in place.  If I export the data using data loader or excel connector, all of the IDs will change as I import it to the Sandbox.  Will I need to recreate all of the child and lookup relationships manually, or is there a trick that can be used to avoid that?
I'm puzzling over this too.  There doesn't seem to be a way to do this in Apex Data Loader - I thought Update might work but it doesn't.
I've got the same task...  Still working on a solution.