5
We are using Kingswaysoft to move the data into Dynamics. We've used bulk delete to get clean up System Jobs, etc. but that seems to be a drop in the bucket. Is this typical? A lot of it seems to be tied up in Activities and Appointments. Is there a way to compress the data?
Hi,
Greetings!
Please note, each Dynamics 365 entity (table) has additional system fields like Created On, Modified On, Created By, Modified By etc. Because of these additional fields/data, Dynamics 365 database size is greater than the data imported.
Regarding, compression, I am not sure how it impacts the performance.
However, to reduce database size, I would recommend one of the following ways:
Tweaking D365 Database Configuration (like indexing, compression etc.) may lead to unexpected results. To avoid this, it is recommended to open a ticket with Microsoft or your Partner to get suggestions on DB Configuration and Optimization.
Let me know if you need more clarification.
Best,
Wahaj
(if it helps, please mark it as verified)
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (