Skip to main content

Notifications

Announcements

Announcing Category Subscriptions!
News and Announcements icon
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / What is the best way t...
Customer experience | Sales, Customer Insights,...
Suggested answer

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

(0) ShareShare
ReportReport
Posted on by dxshyam 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
  • Suggested answer
    Ray Profile Picture
    Ray 1,505 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,964 Super User 2024 Season 1 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

News and Announcements

Announcing Category Subscriptions!

Quick Links

photo of Muhammad Affan

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

thumbnail image of a pie chart section

Top 10 leaders for November!

Congratulations to our November super stars!

thumbnail image of the word Tip

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,359 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans