VistaDB

From Wikipedia, the free encyclopedia

VistaDB

VistaDB 3.0 managed SQL database engine for .NET
Developer:	Vista Software
Latest release:	3.0 / November 10, 2006
OS:	.NET 1.1 .NET 2.0 64-bit .NET .NET Compact Framework Mono
Use:	Managed SQL database engine
License:	Commercial
Website:	www.vistadb.net

VistaDB is the world's first fully managed and typesafe SQL database engine designed for the Microsoft .NET Framework and .NET Compact Framework platforms. VistaDB enables .NET developers to build robust small to midsize WinForms and ASP.NET applications that can run on desktops, servers, web servers, and mobile devices using C#, Visual Basic .NET, Delphi.NET, and other .NET CLR-compliant languages.

Key features include Microsoft SQL Server T-SQL syntax compatibility, a small 600KB single-file managed assembly with built-in ADO.NET Data Provider, full Unicode support, robust and secure data store with support for rich data types, large data capacity database, high-speed data processing, Copy 'n Go!™ deployment, royalty free distribution and much more. VistaDB's 600KB managed assembly is 50 times smaller than Microsft SQL Express and MSDE, and VistaDB is over 40 times smaller than the Jet.

[edit] Features

Fully managed and typesafe SQL database engine
V-SQL query processor compatible with Microsoft SQL Server Transact-SQL syntax
Small single-assembly 600KB embedded footprint includes data engine, SQL query processor, Direct Data Access objects and .NET Data Provider
Deep integration into the Visual Studio 2005 IDE with integrated support for Server Explorer
Unicode support (NChar, NText and NVarchar support)
Intelligent low-level data encoding engine supports both ANSI and UTF-16 for highly optimized data storage
100% variable length data store architecture
Support for storing native .NET data types in addition to traditional SQL data types
StoredCode support lets you store .NET functions and procedures written in managed C# or Visual Basic .NET directly into a VistaDB database, which can be loaded and JIT'd at runtime to provide powerful data management using the entire .NET Framework at your disposal. Stored Code is more powerful than traditional exclusively SQL-based Stored Procedures and Triggers.
Fully managed Data Builder tool allows developers to visually create and manage databases (Visual C# source code is included)
Fully managed Data Migration Wizard migrates existing databases to VistaDB database format (Visual C# source code is included)
XML support compatible with Microsoft SQL Server 2005
Supports the .NET Framework 1.1, the NET Framework 2.0, the Compact Framework 1.1, the Compact Framework 2.0, the 64-bit .NET Framework and Mono
Supports CLR compliant languages only (Visual C#, Visual Basic .NET, Delphi.NET, C++.NET, etc.)
Supports .NET IDEs only (Visual Studio 2003, Visual Studio 2005, Borland Developer Studio 2005, Borland Developer Studio 2006, SharpDevelop etc.)
Supports Windows Mobile 5.0 for Pocket PC
Supports Windows Mobile 5.0 for Smartphone
Easy Copy 'n Go! deployment using XCopy and FTP does not require access to the registry, Windows folder or GAC on client machines
DataTable enables the high-speed DDA objects to work with databound controls
Full support for Microsoft's ILMerge utility that allows you to fully embed the VistaDB assembly directly into your EXEs or DLLs.
Full support for ADO.NET 2.0 and all databound controls
Native .NET Direct Data Access objects
Blowfish encryption
Data store supports 4TB of data, 64,000 tables, and 4GB of data per row
Royalty free distribution