I'm looking to find what would be the best way to migrate millions of records from one org to another (prod to prod). Eg. I have 7+ million cases to move and related Accounts, and other data.
- Is using external id with old orgs Id a better way to handle relationships? Including user mapping to owner of records?
- Is there a way to calculate the time it would take to migrate my data (like mbps etc)? This is also to calculate our approximate or minimum down time as well.
Note: I've tried jitterbit before for another migration of data from a sandbox to another sandbox / prod. But the volume was in little over couple of hundred records.
Appreciate experts' suggestion on this.