Microsoft SQL Server Express: Version Comparison Matrix and Free Downloads
Microsoft SQL Server is an enterprise quality database management system that's usually hosted by a server and can scale across multiple servers and locations.
For local PC, small databases, and less critical situations, Microsoft offers a limited version of SQL Server called SQL Server Express. SQL Server Express can be downloaded for free and installed on your local PC. This is helpful for:
- Deploying desktop Windows solutions that use SQL Server databases to users who don't own SQL Server
- Deploying lightweight web applications that use SQL Server databases
- Developers wanting to create and test applications with a SQL Server database on their own, rather than a database hosted on a server
There are many editions of the full version of SQL Server with Enterprise, Standard and Web being the most common. Here are some of the major differences of the 2017 version compared to the 2016 and 2017 Express editions:
| Enterprise | Standard | Web | 2019 Express | 2017 Express | 2016 Express | |
| Maximum Database Size | 524 PB | 524 PB | 524 PB | 10 GB | 10 GB | 10 GB |
| Compute Capacity | OS Max | 4 sockets or 24 cores | 4 sockets or 16 cores | 1 socket or 4 cores | 1 socket or 4 cores | 1 socket or 4 cores |
| Maximum Memory | OS Max | 128 GB | 64 GB | 1.4 GB | 1.4 GB | 1.4 GB |
| Database Mirroring |  | | | |  | |
| Smart Backups, Encrypted Backups | | | | | | |
| SQL Profiler | | | | | | |
The most critical issue is the maximum database size. The other differences are related to performance and maintenance.
For more details, visit Microsoft's Supported Features of SQL Server 2019.
Note: SQL Server Express cannot be installed on a compressed drive. It only supports standard, non-compressed drives.
No comments:
Post a Comment