CRM Approach RRS feed

  • Question

  • Hi All,

    I need to update I million record in CRM Entity, what is  the right approach for this.



    Thursday, April 14, 2016 12:38 PM

All replies

  • Hello,

    Does the update of a record depend of the updated data of the previous record? If not, and you want to achieve this in a supported manner, I recommend using the ExecuteMultipleRequest class (and in it you store a list of UpdateRequest objects). Also, you need to create a List<ExecuteMultipleRequest> containing several ExecuteMultipleRequest, each having maximum 1000 Requests (UpdateRequest).

    Once you have this list in place, you can iterate through it with by using Parallel.ForEach .

    If you have other possibilities (on-premise with sql database), you can try an unsupported way of achieving it, directly in the database (saves time, but not recommended due to the lack of business constraints).

    Let me know if you need more info regarding the above.

    Thank you,


    Cornel Croitoriu - Senior Software Developer

    If this post answers your question, please click "Mark As Answer" on the post and "Mark as Helpful"


    Thursday, April 14, 2016 2:12 PM
  • Hi Jyotsna,

    What is it you want to update? You can either write code and utilize what Cornel is writing or you can use a third party tool like Kingswaysoft. It pretty much depends on what you want to do.


    Rickard Norström Developer CRM-Konsulterna
    Swedish Dynamics CRM Forum: http://www.crmforum.se
    My Blog: http://rickardnorstrom.blogspot.se

    Friday, April 15, 2016 7:38 AM
  • Hi Jyotsna,

    You can create a windows tool where you can use the the execute Multiple request to update the millions of records in the batch of 1000, which would speed up the process.

    Alternatively you can use the third party tools like KingswaySoft SSIS toolkit or Scribe.


    Dynamics CRM MVP | Inogic | http://inogic.blogspot.com| news at inogic dot com

    If this post answers your question, please click "Mark As Answer" on the post and "Mark as Helpful"

    • Edited by Sam-Inogic Saturday, April 16, 2016 7:35 AM
    Saturday, April 16, 2016 7:29 AM
  • Hi,

    Follow the below link to complete.


    Monday, April 18, 2016 6:02 AM