Design
This tool connects to a source org and a target org. It selects the records from the source org based on JSON object mapping (discussed in following sections) and inserts/upserts into the target org.
Tool provides multiple services.
-
SfdcApiService: This is a SOQL service which handles querying/insert/update/deletion of data. MetadataCompareService: Lets you compare the metadata for an object between source and target orgs.
-
MappingGeneratorService: This service generates the JSON object relationship mapping. You may want to edit the mappings, specially the lookup keys. All fields are mapped unless they are excluded, also, make sure to review and edit JSON object relationship structure. Edit for lookups references. Edit for parents references. Any other references, like owner etc.
-
ValidatorService: Using this service, once the data has been migrated, you can compare the records in source and target orgs.
Given a list of object names, the tool generates the JSON object relationship mapping. However, you may want to edit the JSON mapping, specially for lookup keys.
Let’s consider the below object relationship between three objects. FulfillmentProvider__c and FulfillmentParameterDefinition__c are parent-child objects, FulfillmentProvider__c has a lookup to CloudServiceProvider object.
The JSON object mapping for above related objects will look like this:
Once you have your JSON mapping ready, you are good to experiment.