Customer Engagement & Dynamics CRM Forum

  • 1.  How can I delete a large number of records

    SILVER CONTRIBUTOR
    Posted 3 days ago
    I have tens of thousands of records (orders and line items) I need to remove from the CRM. The out-of-the-box method is far too limiting, even the XRMToolbox utility limits the deletion to 1k records at a time and won't work. I have over 150k records to remove and I'd like to not spend several days on this task if possible. Is there a method/utility that allows for the removal of over 5k records per run?

    ------------------------------
    keith courtemanche
    FCS
    ------------------------------


  • 2.  RE: How can I delete a large number of records

    TOP CONTRIBUTOR
    Posted 3 days ago
    Yep - good old bulk delete job. Define a view that has the rows you want to delete and run a bulk delete job against it.

    See Dynamics 365 Bulk Delete Jobs - Carl de Souza for the how to.

    ------------------------------
    Donal McCarthy
    Digital Marketing Administrator
    BrightWork
    Galway
    ------------------------------



  • 3.  RE: How can I delete a large number of records

    TOP CONTRIBUTOR
    Posted 3 days ago
    Hi @Keith Courtemanche,

    Try the Bulk Record Deletion tool in XRMTB from Andy Popkin.

    ------------------------------
    Ryan Perry
    ------------------------------



  • 4.  RE: How can I delete a large number of records

    MICROSOFT MVP
    Posted 2 days ago
    XrmToolBox tool Bulk Data Updater, see more info: https://jonasr.app/bdu/
    It can delete many many records 🙂

    ------------------------------
    Jonas Rapp
    MVP
    Sweden
    ------------------------------



If you've found this thread useful, dive deeper into User Group community content by role