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.
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?
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.