ERPTimes Spotlight — Advaiya Solutions
Change tracking is one of those Business Central features that quietly becomes a liability. Turn on Change Log for the tables that matter — sales, purchasing, master data — and within a year or two the table itself can balloon into one of the largest in your database. You need the history for audits and compliance. You don’t need it sitting inside your live ERP database, slowing down backups and eating into performance.
That’s the specific problem Advaiya Solutions built Change Log Archival to solve, now live on Microsoft Marketplace.
Change Log Archival – What it does
Instead of leaving historical change log entries inside Business Central indefinitely, the app archives them to Azure Blob Storage — outside the core ERP database, but still fully accessible, searchable, and audit-ready.
Key capabilities:
- Secure archival in structured batches — historical entries move to Azure Blob Storage in a way that reduces database size while preserving long-term compliance records
- Automated high-volume processing — large volumes of change logs are archived automatically in optimized batches, without manual intervention
- Azure connection validation — Blob credentials are validated before archival starts, so misconfiguration doesn’t cause failed uploads mid-process
- Full archival traceability — detailed upload logs with batch and file references, giving auditors complete transparency into what was archived and when
- Historical, date-range archival — supports retrospective archival for backdated statutory or audit requirements, not just ongoing logs
- Pre-deletion validation — archived data is validated against the original before anything is deleted from Business Central, so nothing is lost in the process
Why it matters
The tension here is real for any org that’s been live on BC for a few years: statutory and internal audit requirements often demand long-term retention, but nobody wants that data physically bloating the production database. Advaiya’s approach — validate, archive, then safely delete — means you get both: a lean, performant ERP database, and a fully traceable, searchable archive you can filter by date, table name, user, or document key when an auditor actually asks.
Advaiya Solutions framed it this way at launch: organizations need accurate change tracking for accountability and compliance, but retaining large volumes of logs inside the ERP system impacts performance over time – moving long-term data to Azure Blob Storage reduces that storage cost while keeping the audit trail intact.
Quick link: Click here