We are migrating records from one org to another org and I ran into this scenario.
- We have two objects with master detail relation between them and API names are
- On each object, we have External Id column named
External_Id__cto make the data migration easier when moving between environments.
Here is the simple schema of the data.
We have two records in
Master__cobject and 4 records(two records corresponding to each record in master) in
It is straight forward that first we should move
Master__crecords and then
First, I loaded Master__c records by selecting Upsert Operation in Dataloader and selecting column
External_Id__cas external Id and it went fine.
Can I migrate Detail__c records using Upsert operation given that
Detail__c.External_Id__c values are not unique?
I was told by the person who designed that he chose to populate the
Detail__c.External_Id__c field to match with its parent record
MasterId__r.External_Id__c and mentioned that there are some tools to handle this kind of data when moving between environments. Can someone explain me on how to do this?
Note: I am not looking for crazy vlookup operation.