|
Comparison of .NET Databases for Visual Studio
| Deployment and Installation |
Feature |
SQL Server Express |
SQL Server Compact |
TurboDB Managed |
| Installation Size |
197 MB |
1,8 MB |
0,8 MB |
| Non-admin installation option |
|
|
|
| Runs on Windows Mobile platform |
|
|
|
| Installed centrally with an MSI |
|
|
|
| Native 64-Bit support |
 (WoW) |
 (ab 3.1) |
|
| Completely embedded in application |
|
|
|
| Installation by copying (xcopy deployment) |
|
|
|
| Properties of the Database File |
Feature |
SQL Server Express |
SQL Server Compact |
TurboDB Managed |
| File format |
Multiple files |
One file |
One file |
| Support for different file extensions |
|
|
|
| Database size support |
4 GB |
4 GB |
2 GB + 16 TB Blobs/Tab. |
| Database file encryption |
|
|
|
| Code free, document safe, file format |
|
|
|
| Multi-user access |
|
|
|
| Queries and Programmability |
Feature |
SQL Server Express |
SQL Server Compact |
TurboDB Managed |
| Common Query Features |
|
|
|
| Procedural SQL |
|
|
|
| Simple transactions |
|
|
|
| Stored procedures |
|
|
|
| Full-text search |
 - |
|
|
| Others |
Feature |
SQL Server Express |
SQL Server Compact |
TurboDB Managed |
| Free technical support from developers |
|
|
|
SQL Server Express and SQL Server Compact are trademarks of Microsoft Corporation.
|