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
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)
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 -
.
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
Hello,
I believe "Bulk Delete" is what you're looking for - www.encorebusiness.com/.../bulk-delete-records-dynamics-crm
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.
#1
André Arnaud de Cal...
291,711
Super User 2024 Season 2
#2
Martin Dráb
230,458
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
