|
|
Comparison of .NET Databases for Visual Studio
| Deployment and Installation |
|
Feature
|
SQL Server Express
|
SQL Server Compact
|
TurboDB
for .NET
|
| 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)
|

(since3.1)
|
|
| Completely embedded in application |
|
|
|
| Installation by copying (xcopy deployment) |
|
|
|
| Properties of the Database File |
|
Feature
|
SQL Server Express
|
SQL Server Compact
|
TurboDB
for .NET
|
| 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
for .NET
|
| Common Query Features |
|
|
|
| Procedural SQL |
|
|
|
| Simple transactions |
|
|
|
| Stored procedures |
|
|
|
| Full-text search |
 -
|
|
|
| Others |
|
Feature
|
SQL Server Express
|
SQL Server Compact
|
TurboDB
for .NET
|
| Free technical support from developers |
|
|
|
SQL Server Express and SQL Server Compact are trademarks
of Microsoft Corporation.
|