Answered

Deleting of all Entity Records in One Shot

(0) Share

Report

Posted on by Jerry P.

225

I have a project transaction entity and occasionally the need to delete all the records and re-import comes up. This entity is approaching 100K records and using the default delete command would be very efficient. For my on-premise development I can truncate the table and then re-import. Production is online. Is there a way to issue a truncate command or a bulk delete all records in one shot?

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (1)

HarryZang 240 on at

Like (0)

Report

RE: Deleting of all Entity Records in One Shot

Online environment does not have direct access to the SQL database, so the bulk delete must through either using the oob "bulk delete" function in data management section, or you may able to write a console application to do that. Both are much slower than "truncate the table" operation (although direct DB operation is not a supported method)

Was this reply helpful? Yes No
Suggested answer

gdas 50,091 Moderator on at

Like (0)

Report

RE: Deleting of all Entity Records in One Shot

Hi Jerry ,

Use OOB bulk delete which is only the best options available in dynamics CRM , as you don't need worry about the deletion error or any issues and advantages is that its async process.

Take a look below video for more details -

www.youtube.com/watch

.

Was this reply helpful? Yes No
Suggested answer

sandeepstw 4,601 on at

Like (0)

Report

RE: Deleting of all Entity Records in One Shot

Hi,

You can do using copy to sandbox instance and reset then again upload in production. You can take help from this blog.

www.powerobjects.com/.../reset-production-instances-in-crm-online

Was this reply helpful? Yes No
Suggested answer

a33ik 84,331 Most Valuable Professional on at

Like (1)

Report

RE: Deleting of all Entity Records in One Shot

Hello,

I believe "Bulk Delete" is what you're looking for - www.encorebusiness.com/.../bulk-delete-records-dynamics-crm

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (1)

Report

RE: Deleting of all Entity Records in One Shot

Under Settings|Data Management you will see an option called Bulk Record Deletion. Create a New bulk record delete job ... Just need to define a search criteria (the project transaction entity) and submit the job.

Was this reply helpful? Yes No