What you get with VistaDB 4

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, Entity Framework Provider, samples and help files.

Embedded SQL Database Engine

• 100% fully managed and typesafe (Developed in C#)
• 1 MB footprint with XCopy deployment
• Single and multi-user support
• Supports .NET 2.0, .NET 3.0, .NET 3.5, .NET 4.0, and Mono 2.6+
• T-SQL compatible query processor
• SQL Server 2005 syntax support (SELECT, INSERT, DELETE etc.)
• Royalty free distribution of database runtime to your customers
• 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
• Native 64 bit support on Windows 64 bit platforms

ADO.NET Data Providers for .NET, and Mono 2.6 or higher

• 100% fully managed and typesafe (Developed in C#)
• Visual Studio 2008 / 2010 / 2012 Server Explorer and visual query creation
• VistaDBCommand, VistaDBCommandBuilder, VistaDBConnection, VistaDBDataAdapter, VistaDBDataReader, VistaDBParameter, VistaDBProviderFactory (Full support for managed ado.net provider factory applications)
• Full Entity Framework support for model generation and runtime from VS 2008 or 2010
• ASP.Net Membership Providers (optional source code available)

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
• Full Text Search (FTS) indexes

Data Management Tools

• Data Migration Wizard migrates data from existing Access, SQL Server, and SQL CE databases
  • Scriptable from the command line
  • Data Migration Pak with source code is available as an Addon to allow customization and distribution
• Data Builder utility lets you visually create and manage VistaDB databases
• Full integration with Visual Studio 2008 / 2010 Server Explorer