Skip to main content

Notifications

Microsoft Dynamics CRM (Archived)

Want to clear out CRM data

Posted on by 7,392 User Group Leader

Hi All,

I've been customizing Dynamics 365 and during the process, I have put a lot of test data across various entities.

Now, I want to clear out all the data to start using the system as fresh and live.

Quickest way to do this?

Kindly advise. Thanks.

*This post is locked for comments

  • Suggested answer
    Priyesh Profile Picture
    Priyesh 7,392 User Group Leader on at
    RE: Want to clear out CRM data

    So bottom line, use Bulk Delete if there a countable number or entities to be cleared and you're not needed to clean the environment often.

  • ashlega Profile Picture
    ashlega 34,475 on at
    RE: Want to clear out CRM data

    I had a somewhat similar situation on the last project, but it wasn't a one-off cleanup - had to do it periodically.. so ended up creating an SSIS package for that. Now I can run it any time I want to clean up all the test data.

  • abhishek_255 Profile Picture
    abhishek_255 1,612 on at
    RE: Want to clear out CRM data

    In case you don't want to do bulk delete. Then

    Online-You can reset sandbox instance. And deploy customizations.

    Onpremise - Disable crm instance, delete crm database and create a new organization with same name and deploy customizations to fresh instance.

  • Priyesh Profile Picture
    Priyesh 7,392 User Group Leader on at
    RE: Want to clear out CRM data

    Yes, I too had my thoughts around Bulk Delete. But I was hoping that we might have an option to clear out all the data just but running a tool or simpler steps than Bulk Deletion.

  • Suggested answer
    Aric Levin Profile Picture
    Aric Levin 30,188 on at
    RE: Want to clear out CRM data

    You can either use Bulk Delete, to delete all records from the various entities or an SSIS package that you can create.

    I don't think there is any tool that is available to do that.

    You might be able to use the Bulk Workflow Execution from XRMToolbox, but that would mean that you would have to create the delete workflows, and would probably take just as much time.

  • Suggested answer
    Kishor Kumar Profile Picture
    Kishor Kumar 3,702 on at
    RE: Want to clear out CRM data

    Use Bulk Delete Option if you want to clear the data fully.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans