web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
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
I have the same question (0)
  • Bipin D365 Profile Picture
    Bipin D365 28,983 Moderator on at
    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
     
  • dxshyam Profile Picture
    dxshyam 230 on at
    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
  • Suggested answer
    Ray Profile Picture
    Ray 1,537 on at
    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.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the January Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
ManoVerse Profile Picture

ManoVerse 120 Super User 2026 Season 1

#2
Jimmy Passeti Profile Picture

Jimmy Passeti 46 Most Valuable Professional

#3
NeerajPawar Profile Picture

NeerajPawar 41

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans