|
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.
|