SQL Server Compact Edition (the original name is SQL Server Everywhere ) is a Microsoft product in the SQL Server line that is a version of SQL Server Mobile with the Win32 prohibition removed and the license changed. Product released January 11, 2007 . The latest release is SQL Server Compact 4.0, with support for the .NET Framework 4.0 and running under 32-bit and 64-bit versions of Windows.
| Microsoft SQL Server Compact 4.0 | |
|---|---|
| Type of | Relational DBMS |
| Developer | Microsoft |
| Written on | C , C ++ , C # |
| operating system | Microsoft Windows |
| Latest version | 4.0.8876.1 ( June 5, 2012 ) |
| License | Microsoft EULA |
| Site | www.microsoft.com |
SQL Server Compact is based on the same code as SQL Server Mobile. The database is stored in a single file whose format matches the format of the “mobile” version. This file format and engine has been used for several years in some Microsoft desktop products, in particular, in the MSN client. Unlike SQL Server Express, running as a separate service, SQL Server Compact runs in-proc, that is, as part of the calling process.
The limit on the maximum database file size is 4 GB. However, it later became known [1] that the 4 GB limit is purely technical (due to the fact that the DBMS was originally used on devices where 4 GB is more than enough), and therefore will be changed in future versions.
Using SQL Server Compact for web applications under IIS is not possible (software and licensing restrictions). It was later announced [2] that it is possible to use SQL CE from under IIS in the new version. To do this, you must run AppDomain.CurrentDomain.SetData("SQLServerCompactEditionUnderWebHosting", true) before using the library. However, this approach is not recommended, since SQL CE is not optimized for simultaneous access by a large number of users.
Multi-user work with a single database file from different computers is not supported due to technical difficulties. However, access from different processes on the same computer is quite possible and is standard.
In February 2013, Microsoft announced that SQL Server Compact Edition is outdated.
Although no new versions or upgrades are planned, Microsoft will continue to support SQL Compact using standard lifecycle support policies. This support will end in July 2021.