Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
CRM Approach RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi All,

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

    Thanks,

    Jyotsna

    Thursday, April 14, 2016 12:38 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

    Cornel Croitoriu - Senior Software Developer

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

    Biz-Forward.comCroitoriu.NET


    Thursday, April 14, 2016 2:12 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    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.

    Regards

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

    Friday, April 15, 2016 7:38 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    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.

    Thanks

    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
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    Follow the below link to complete.

    https://msdn.microsoft.com/en-us/library/jj863631.aspx

    Monday, April 18, 2016 6:02 AM