VistaDB consists of an embedded SQL database engine, built-in
SQL query processor, ADO.NET Data Provider, 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 1.2.x
- 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
- 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#)
- Support Visual Studio 2005 / 2008 Server Explorer
- 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
- Stores up to 4TB of data with 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, CLR Triggers, Views, Constraints, Relationships, Primary & Foreign keys
- Native 64 bit support on Windows x64 platforms
- Full Text Search (FTS) indexes
- No CPU or RAM usage limits
Data Management Tools
- Tools are fully managed and typesafe (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
