|
What You Get
|
VistaDB
|
|
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 to allow customization and distribution
|
|
|
Data Builder utility lets you visually create and manage VistaDB databases
|
|
|
Full integration with Visual Studio 2008 / 2010 / 2012 Server Explorer
|
|