web
You’re offline. This is a read only version of the page.
close
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 (Archived) / Migration from account...
Microsoft Dynamics CRM (Archived)

Migration from accounts to contact entity

(0) ShareShare
ReportReport
Posted on by Tin 1,562

Hello Experts, In CRM by mistake bulk accounts(around 400,000) are created.

Now i want to migrate these accounts into contact with all relationship entities like:opportunity,lead,case,invoice, orders..etc. we can do this by two approach:

1.can do migration with same GUID as of account have.

2.Can do with create new contact GUID .

Can anyone suggest me which one i'll take forward.

so after migration it will not impact running system. 

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    razdynamics Profile Picture
    razdynamics 17,308 User Group Leader on at

    Hi Tin,

    1. No you cant use same Guids all records should have unique guids

    2. Yes you can force your import to allow crm to create guid which is recommenmed approach for imports

    Why don't you do a bulk Delete Job on the Accounts you Imported, and import the Constacts?

    Also  what method are you using to import these records?

    Best Wishes, Raz

  • Tin Profile Picture
    Tin 1,562 on at

    Hello Raz,

    I am doing migration by SCRIBE tool.

    So,I just take a record from account entity and push it into contact entity.

    After migration I'll disable all migrated accounts records,i can't delete it.

    Can you give me any valid reason why I have to go with new GUID?

    If I'll use same GUID what accounts have I don't have to do too much work for

    relationship migration.It will just done by SQL UPDATE query by set object type =2.

    Please suggest me i am in bit confusion,I have two approaches which one is more fisiable I don't know.

  • Suggested answer
    razdynamics Profile Picture
    razdynamics 17,308 User Group Leader on at

    Hi tin, Your Approach is not recommended approach as it will affect the CRM functionality in the long run

    Scribe makes it easy for you to import so why not import the Contacts Correctly, and Run a Bulk Delete job on the Accounts you imported, maybe using the Created on or identifier / view for imported accounts?

  • Tin Profile Picture
    Tin 1,562 on at

    Hi Raz,

    first Thanks for you interest....

    You are right I am also think so,but don't know the valid reason why have not taken with same GUID instead of creating new.

    I am using Scribe for the import accounts to contacts after the mapping fields.

    Then after I find contacts with new GUID...I'll update these new GUID into other related

    entities like opportunity,lead,activity....etc. to making relationship like same as i have in account entity.

    As you suggest me i haven't continue with same GUID but did you have any valid reason?

    I just straight way for the account to contacts migration because I have 400000 records

    in live environment.

    Please suggest me ..........with reason,I haven't any idea which one is good approach or which bad.

  • Suggested answer
    razdynamics Profile Picture
    razdynamics 17,308 User Group Leader on at

    The Microsoft Dynamics CRM SDK Best practices for developing with Microsoft Dynamics CRM, states, Allow the system to automatically assign the GUID (Id) for you instead of manually creating it yourself. This suggestion allows Microsoft Dynamics CRM to take advantage of sequential GUIDs, which provide better SQL performance.

    Also you don't want to cause confusion to your users where guids for 2 different records are the same, even if they do have different object ids

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans