Dynamics 365 Business Central: the problem of large data deletion.

The article discusses the challenges of performing large data deletions in Dynamics 365 Business Central SaaS and on-premises environments. In the SaaS environment, data deletions can only be done through AL procedures, which can be time-consuming for large tables. The article suggests deleting rows in smaller batches to avoid locking the table for too long. In the on-premises environment, the article recommends using SQL operations like TRUNCATE TABLE or DROP TABLE for efficient data deletions. The article also emphasizes the importance of having a data retention strategy in place and applying retention policies from the beginning of the project.

Article 1m Stefano Demiliani

---

Login now to access my digest by 365.Training

Login