VistaDB consists of an embedded SQL database engine, built-in
TSQL query processor, ADO.NET Data Provider Factory, Direct Data Access objects, robust
Data Store, data management tools, samples and reference help files.
Embedded SQL Database Engine
- 100% fully managed and typesafe (Developed in C#)
- Less than 1 MB footprint with XCopy deployment
- Single and multi-user support
- Supports .NET 2.0, .NET 3.0, .NET 3.5, CF 2.0 and Mono
- T-SQL compatible query processor
- SQL Server 2005 syntax support (SELECT, INSERT, DELETE etc.)
- Royalty free distribution
- Snapshot isolation level Transaction Processing
- Zero configuration and zero administration (even runs as guest on
Windows Vista)
- No CPU or RAM limits imposed by the engine
ADO.NET Data Providers for .NET, CF and Mono
- 100% fully managed and typesafe (Developed in C#)
- Visual Studio 2005 / 2008 Server Explorer and visual query
creation
- VistaDBCommand, VistaDBCommandBuilder, VistaDBConnection,
VistaDBDataAdapter, VistaDBDataReader, VistaDBParameter,
VistaDBProviderFactory (Full support for managed provider factory applications)
- ASP.Net MembershipProvider including source code
Data Store (Database)
- Single file database, integrates all tables, indexes, and CLR data into a single file
- File storage limited only by available RAM and hardware
- Up to 64,000 tables per database
- Data types are highly compatible with SQL Server 2005
- Secure Blowfish encryption and password protection
- High-speed indexes and Full-Text Search
- CLR Procs, TSQL Procs, CLR Triggers, Views, Constraints, Relationships, Primary & Foreign keys
- Table Value Params
- Native 64 bit support on Windows 64 bit platforms
- Full Text Search (FTS) indexes
Data Management Tools
- Tools are fully managed and type safe (C# source is available)
- Data Migration Wizard migrates data from existing databases to VistaDB 3.x
- Data Builder utility lets you visually create and manage VistaDB databases
- Full integration with Visual Studio 2005 / 2008 Server Explorer
