Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archive) / Data Migration Utility...
Microsoft Dynamics CRM (Archive)
Suggested answer

Data Migration Utility Issue in CRM

(0) ShareShare
ReportReport
Posted on by Faran Saleem 295

Hi all,

I am trying to migrate data from Organization A to Organization B.

The entity that I am trying to import data for has structure as such that it contains self join (It has a parent child lookup). The parent lookup is also the same entity.

The issue that I am facing is that when I try to export it exports fine and when I check XML file I also see my record as I want it to but when I import this in the target environment, the lookup reference does not get resolved and it comes as empty, however, the lookup record is already available on the target environment.

How can I solve this issue? Because I am using automated deployments and I need to have a permanent fix for this.

I am using CRM v8.2

Categories:
Development / Customization / SDK
  • Suggested answer
    Robert Proell Profile Picture
    Robert Proell 20 on at
    RE: Data Migration Utility Issue in CRM

    Hi Faran,

    my approach would be a 2 phase import process.

    1. Import all entities. (remove parent lookup attribute)

    2. Update parent lookup attributes.

    If this is a one time operation you might can use the free version of: KDDM: https://docs.kuppsoft.com/KD-Tooling-Deployment/Reference/Steps/ExportDataStep
    (    Is a commercial product for enterprise projects but the community version is free for local execution) 

    CI/CD:
    To include it to your automated deployments you will need some kind of custom script. 
    Should be possible within a few hours, depending on your data set (paging etc. )

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Community Spotlight of the Month

Kudos to Mohamed Amine Mahmoudi!

Blog subscriptions now enabled!

Follow your favorite blogs

TechTalk: How Dataverse and Microsoft Fabric powers ...

Explore the latest advancements in data export and integration within ...

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 283,860 Test role Public

#2
Ludwig Reinhard Profile Picture

Ludwig Reinhard Microsoft Employee

#3
Martin Dráb Profile Picture

Martin Dráb 225,155 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans