Share via


Simplify Store Commerce offline database size management

Enabled for Public preview General availability
Users by admins, makers, or analysts - Apr 1, 2025

Business value

Proactive offline database size management reduces the time and effort needed to manage database size. Automatic recovery of offline databases that exceed the size limit reduces downtime for point of sale (POS) devices and saves the cost and time of manual recovery.

Feature details

Dynamics 365 Commerce customers use the offline capabilities of the Store Commerce app to maintain business continuity during network or service interruptions. Additionally, most customers using Store Commerce offline use SQL Server Express for their offline database, which limits the database size.

With automatic, proactive compression and removal of large indexes, you can prevent the Store Commerce offline database from exceeding the SQL Server Express size limit. By using index compression with extension tables, you can reduce the size of the offline database.

Automatic index compression and removal capabilities speed up and ease the recovery of offline databases that exceed the size limit.

Administrators use the feature management workspace to enable these capabilities for their organization.

Geographic areas

Visit the Explore Feature Geography report for Microsoft Azure areas where this feature is planned or available.

Language availability

Visit the Explore Feature Language report for information on this feature's availability.

Additional resources

Commerce database index compression (docs)