how do I migration data from one live org to another? We have a requirement to move data from objects which include account, contact opportunities, related activities and a bunch of custom objects. Below are some of the ways that I have come through..
- Good old data loader
- Informatica pluggin
- Write a webservice in the destination org to pull in data from the source org.
- Any other?
Which approach should I choose for this.
Best Answer
I'm currently in the midst of this for an org of
Account-Contact-Case-CaseComment-Task
(a thankless task)I'm planning on a specific runningUser + Data Loader + triggers as you can do several things
CreatedDate
andLastModifiedDate
errorXXXXX.csv
fileAccount.ParentId
in most cases if the input is sorted by ascending ID (recommend only if you have sparse use of hierarchies - otherwise multiple passes on the object are required).