› Dynamics 365, Enterprise › Data Migration for Many to Many Relationship Entities in D365 PSA

Data Migration for Many to Many Relationship Entities in D365 PSA

Shailesh Wath
ERP Consultant
Published on December 29, 2017
Category: Dynamics 365, Enterprise

Introduction:

This blog explains how to migrate data for Many to Many or N:N relationship records.

Scenario:

Client always demand configuration records to be migrated from Test Env to a Production Environment.We can migrate data for Entity records and Entities with 1:N relationships records however we cannot directly migrate data for N:N relationship( intermediate entity) which is not exposed in D365 PSA. This can be achieved by using XRM Tool Box plugin – Manage NN relationships.

Prerequistive:

· XRM Tool Box with “Manage NN relationships” plugin installed.
· Both entities having alternate key with data – This is required as a cleaner approach.

Below steps explains how to achieve requirement.

Steps of Implementation:

1. Open “Manage NN relationships” plugin in XRM tool box with Source Organization as connected.

2. Click Load Metadata button and then select First Entity with Specific attribute as alternate Key and same for Second Entity as shown below.

manage n-n relationship

3. Click button Export button and save file.

specifying the entities in plugin

4. Open exported file Column A is OrgUnitID and Column B is PriceLevelID data.

export data in csv fomat

5. Change connection to target organization of Manage NN relationship plugin in XRM toolbox and then follow the step 1 and 2.

6. Click Import button and select the file exported in step 3.

7. Data migrated is been tracked in log section of plugin.

Conclusion:

N:N relationship or Many to Many relationship entity records cannot be migrated from D365 PSA as they are not been exposed however this can be achieved by using third party tool like XRM Tool Box – “Manage NN relationship”.

 



Leave a Reply

Your email address will not be published. Required fields are marked *

Time limit is exhausted. Please reload the CAPTCHA.

Looking for a demo?

We will get back to you very soon!
We promise.

  • This field is for validation purposes and should be left unchanged.