Related Links


Bookmark and Share


VistaDB 3 box shot

  • Embedded SQL Database
  • 1 MB single Dll
  • Easy migration from SQL Server
  • TSQL data types and syntax
  • Royalty free distribution
  • ASP.NET and Medium Trust supported for shared hosting

 

What you get with VistaDB 3

Skip Navigation LinksVistaDB.Net > VistaDB 3.x > What you get with VistaDB

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

Data Management Tools

  • DBA Sample Tool with complete C# source code unbranded.  This allows you to quickly build an admin application for your users.
  • Data Migration Wizard migrates data from existing Access, SQL Server, and SQL CE databases
    • Scriptable from the command line for usage in setup tools or deployment to users
  • Data Builder utility lets you visually create and manage VistaDB databases
  • Full integration with Visual Studio 2005 / 2008 Server Explorer li>