As Microsoft Dynamics NAV Demo version based on SQL Express, i get to know the difference between SQL Express and other version and it’s limitation.
There are many editions of the full version of SQL Server with Enterprise, Standard and Web the most common. Here are some of the major differences of the 2016 version compared to the Express edition:
The most critical issue is the maximum database size. The other differences are related to performance and maintenance.
For more details, visit Microsoft’s SQL Server 2016 Comparison of Editions including Enterprise vs. Express
Note: SQL Server Express cannot be installed on a compressed drive. It only supports standard, non-compressed drives.