| Feature | VistaDB Express | VistaDB Subscription | VistaDB Source Edition |
Application Types |
|||
| ASP.NET |  |
|
|
| Windows Forms (WinForms) | |
|
|
| Windows Services | |
|
|
| Console | |
|
|
| LINQ Entity Framework Provider | |
|
|
| Microsoft Sync Services | TBD | TBD | |
| Client / Server Support |
|
|
|
| May be used in Open Source projects (NON GPL) |
|
|
|
Languages |
|||
| C# (w/samples) | |
|
|
| VB.NET (w/samples) | |
|
|
| All other CLR-compliant language are supported | |
|
|
Development IDEs |
|||
| Visual Studio 2008 Standard or higher | |
|
|
| Visual Studio 2005 Standard or higher | |
|
|
Non GUI Development IDEs (no Server Explorer) |
|||
| Visual C# Express 2005/ 2008 Express | |
||
| Visual Basic 2005 / 2008 Express | |
||
| Visual C++ 2005 / 2008 Express | |
||
| Visual Web Developer 2008 Express | |
||
.NET Platforms |
|||
| ASP.NET 2 ( Shared Hosting / Medium Trust is ok) | |
|
|
.NET Framework 2 - 3.5  Windows
2000/XP/Vista/Server 2003/Server 2008 |
|
|
|
| .NET Framework 2Windows
2000/XP/Vista/Server 2003/Server 2008 |
|
|
|
| 64-bit .NET Framework | |
|
|
| Mono (.NET 2) Linux, Mac OS X, Solaris, FreeBSD |
|
|
|
| Compact Framework 2 Windows Mobile 5
/ 6 - Pocket PC & Smartphone |
|
|
|
Data Management Tools |
|||
| Data Builder | |
|
|
| Data Migration Wizard | |
|
|
Subscription Benefits |
|||
| Unlimited electronic tech support | |
|
|
| Public forums support | |
|
|
| Development builds | |
|
|
| Free upgrades to new engines during active
subscription (Excludes Server Edition) |
|
|
|
| Archive downloads | |
|
|
| Patches / Updates | 1 Year Subscription | 1 Year Subscription | |
C# Source Code |
|||
| Data Builder C# source code | |
|
|
| Data Migration Wizard C# source code | |
|
|
| VistaDB 3 data engine C# source code | |
||
| .NET Data Provider C# source code (part of data engine) |
|
||
| TSQL compatible query processor C# source
code (part of data engine) |
|
||
| Direct Data Access C# source
code (part of data engine) |
|
||
| VistaDB DataTable component C# source code (part of data engine) |
|
||
| LINQ Entity Framework provider source |
|
||
| ASP.NET Providers (Membership, Role, Profile) | |
|
|
| NUnit tests and examples | |
|
|
Data Engine Features |
|||
| VistaDB 3 data engine | |
|
|
| TSQL compatible query processor | |
|
|
| ADO.NET 2 Provider | |
|
|
| Direct Data Access™ objects (DDA) | |
|
|
| Medium Trust Support | |
|
|
| Allow Partially Trusted Callers Attribute (APTC) | |
|
|
| XCopy deployment | |
|
|
| Single and multi-user LAN support | |
|
|
| Simultaneous multiple connection support | |
|
|
| Database level, table level and row level locking | |
|
|
| In-memory databases and tables (VM backed files) | |
|
|
| XML import and export | |
|
|
| Dynamically create and modify databases | |
|
|
| Connection Pooling | |
|
|
| Simple Full-Text Search Indexes | |
|
|
| ACID Compliant Transaction Processing | |
|
|
| Visual Studio 2005 Server Explorer Designer | |
|
|
| Visual Studio 2008 Server Explorer Designer | |
|
|
| Side-by-side multiple version deployments can co-exist | |
|
|
| Schema's can be altered during shared mode access | |
|
|
Database Features |
|||
| File size limited only by available hardware | limited |
Possible |
Possible |
| Single file data store | |
|
|
| SQL Server 2005 compatible data types | |
|
|
| UNICODE support (NChar, NText, NVarChar) | |
|
|
| CLR Procs - Managed Stored Procedures | |
|
|
| TSQL Stored Procs | |
|
|
| TSQL User Defined Functions (UDFs) | |
|
|
| SQL Views | |
|
|
| Simple Full Text Search Indexes (FTS) | |
|
|
| Constraints | |
|
|
| Primary Keys and Foreign Keys | |
|
|
| Referential integrity | |
|
|
| Cascading deletes and updates | |
|
|
| 128-bit Blowfish encryption (Database, table or column level encryption) |
|
|
|
| Password protect database | |
|
|
| Primary and secondary indexes | |
|
|
| Compression Attribute | |
|
|
| Isolated Storage Supported |
|
|
|
| In Memory based databases (Virtual Memory Backed Files) |
|
|
|
| Relationships | |
|
|
| Default TSQL values per column | |
|
|
| Identity Types | |
|
|
| Image/Binary data storage | |
|
|
| Extended properties (table and column descriptions etc.) | |
|
|
| Database allows custom file extensions | |
|
|