function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Ankit Arora 29Ankit Arora 29 

data migration in many to many relationship

Hello Everyone,

I have two Custom Objects, "Contacts" and "Events". I have multiple contacts associated with multiple Events. So I have created a new "Junction Object - ContactEvent". Now I have created a Master-Details relationship between "ContactEvent & Contacts" and other Master-Detail relationship between "ContactEvent & Events". There are no issues till now.
But I want to migrate data into the salesforce that has Many to Many relationships between Contact and Event, Can you please guide me how to do it? I studied about using Data Loader but we have to import the data and then export it to get Salesforce ID and again match it with the required field and then import it back again, this is a very lengthy process specially when we have millions of records. Is there any other way we can do it using External ID? like not exporting and we can use upsert, insert or update only the new records without exporting
Please let me know. Thank you so much.