[SalesForce] Data Migration from one production org to another

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..

  1. Good old data loader
  2. Informatica pluggin
  3. Write a webservice in the destination org to pull in data from the source org.
  4. 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

  • Preserve the system audit fields like CreatedDate and LastModifiedDate
  • Is partial success-enabled with a builtin retry file in the errorXXXXX.csv file
  • Use triggers to automatically handle the cross-referencing you will need to add a child record to a previously loaded parent record without having to do Excel VLOOKUPs and the like. Can even handle hierarchies like Account.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).
  • Assign default OwnerIds where the incoming ownerId is not an active user anymore