Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM forum
Suggested answer

What is the best way to Bulk Update 15-20 Lakh contact records

Posted on by 230
Greetings!
 
I have around 15 Lakh Contact records in my D365 CRM online.
 
I want to do the following for all the records
 
  1.  Update emailaddress2 of each contact with the value of emailaddress1 where emailaddress1 is Not NULL
  2. Set NULL to emailaddress1
What is the best way to get this done without using SSIS?
 
Thanks
Shyam
Categories:
  • Suggested answer
    Ray Profile Picture
    Ray 1,485 on at
    What is the best way to Bulk Update 15-20 Lakh contact records
    For one-time task, I think the best way is to use the Export function. You can export the contacts(Click the "Dynamics WorkSheet" ribbon) and change the data then Import back.
    If this may need to repeat, I think creating a flow is a good choice. This flow is created to handle a single record and you can batch it in Advanced Find.
  • dxshyam Profile Picture
    dxshyam 230 on at
    What is the best way to Bulk Update 15-20 Lakh contact records
    Hi Bipin,
     
    I think Bulk Data Updater does not have provisions to update field2 with field1's value, I believe it lets us set null or default value. Also, wanted to know if it could handle 15L records and any idea about what would be the ball park time required for it?
     
    We wrote a console application and tested it in a trial environment with 100,000 contact records
     
    The batch size is the default 1000 records, in the initial run the application stopped performing after 2000 records were updated. On re-running the console application again - it executed another 49,000 records and stopped.
     
    On an average it took about 10 mins for 10,000 records, that translates to about 25 hours assuming the console app did not stop in middle.
     
    Do we have an option to execute multiple console jobs at the same time (clones of the same console job) - will this work like parallel processing and reduce the overall time significantly or would it increase the load on the server and result in higher time?
     
    Thank you
    Shyam
  • Bipin D365 Profile Picture
    Bipin D365 28,962 Moderator on at
    What is the best way to Bulk Update 15-20 Lakh contact records
    Hi Shyam,
     
    You can use Bulk Data Updater plugin in xrmtoolbox.
     
    You can also create your own console application and use SDK to update contact records
     

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,570 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,683 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans