Home Products VistaDB 3.3 Features

Features

	Truly embedded ADO.NET 2 SQL database for .NET 2+, CF 2 and Mono Less than 1 MB single assembly deployment Cross-platform Windows, Linux and Mac OS X support using the Mono Project Easy migration from SQL Server TSQL Royalty-free distribution

Database Engine

• 100% fully managed and verifiably typesafe architecture
• Small less than 1 MB footprint
• Royalty-free distribution
• Developed in C#
• Cross-platform support with Mono: Windows, Linux, Mac OS X, Sun Solaris & BSD
• Built-in SQL Server 2005 T-SQL compatible query processor
• Built-in ADO.NET 2 Provider
• Built-in Direct Data Access™ objects (DDA)
• ASP.NET Allow Partially Trusted Callers (APTC) attribute
• ASP.NET Isolated Storage support for alternate way to manage data
• Thread safe
• No number of CPU or RAM usage limitations
• Native 64 bit support on Windows x64 platforms
• ZeroClick™ deployment allows engine to be fully embedded into your application using ILMerge so there are zero additional files to deploy
• Allow Partially Trusted Callers Attribute (APTC)
• Custom VistaDBDataTable component
• Single and multi-user support
• Simultaneous multiple connection support (local processes or multi user across shared network drive)
• Database level, table level and row level locking
• In-memory databases and tables
• XML import and export
• Export to flat files
• Dynamically create and modify databases
• Connection Pooling
• Transaction Processing (ACID)
• Read Committed and Snapshot Transaction Processing
• Side-by-side multiple version deployments can co-exist
• Schema's can be altered using shared mode access
• Write-behind data caching
• Support for |DataDirectory| for asp.net drive mapping

Database Features

• Database supports up to 4TB
• Single file data store (.VDB3 database file)
• SQL Server 2005 compatible data types and syntax
• No CPU or RAM usage limitations
• UNICODE support (NChar, NText, NVarChar)
• Secure Blowfish encryption (32-bit to 448-bit)
• Schema can be altered in Shared Mode
• SQL Views
• CLR Procs and User Defined Functions
• CLR Triggers
• Constraints
• Primary Keys and Foreign Keys
• Referential integrity
• Cascading deletes and updates
• Disk space can be reclaimed
• Granular encryption of database, tables or columns
• Password protect database
• Primary and secondary indexes
• Compression attribute for columns
• Relationships
• Dynamic default values using functions
• Identity Types
• Image data storage (i.e. BLOB)
• Extended properties (table and column descriptions etc.)
• Database allows custom file extensions
• Variable length rows
• Full Text Search indexes
• Read only media support for runtime query

Data Management Tools

Data Builder Tool

• Visually creating and manage database schemas
• Run interactive SQL
• Query Plan support
• Browse, add and edit data
• Visually manage CLR Procs
• Manage Tables, Columns, Indexes, Relationships, Primary and Foreign Keys

Visual Studio 2005 (improved)

• Full integration within Visual Studio 2005 using the Server Explorer

Visual Studio 2008 Beta 2 (new)

• Designer integration within Visual Studio 2008 using the Server Explorer

Data Migration Wizard

• Migrating data from SQL Server, SQL CE, VistaDB 2.x and Access to VistaDB 3.0
• Supports silent mode data migration
• Automatically generates migration logs and re-usable migration scripts

Types of Applications Supported

• ASP.NET apps
• Windows Forms (WinForms) apps
• Windows Services apps
• Windows Console apps
• Mono Gtk# for Linux Desktop and Web Services
• Mono Glade for Linux Desktop and Web Services

Languages Supported

• C# (includes samples)
• VB.NET (includes samples)
• Other CLR-compliant languages (e.g. Delphi.NET, J# etc.)

IDE Support

• Visual Studio 2005 with Server Explorer with non-Express Editions
• Visual Studio 2008 beta 2 (Orcas)
• ASP.NET WebMatrix via code
• SharpDevelop via code
• Borland Developer Studio via code

Platforms Supported

• .NET Framework 3.0/3.5 - for Windows Vista/XP/2000/Server 2003
• .NET Framework 2.0 - for Windows Vista/XP/2000/Server 2003
• 64-bit .NET Framework - for Server 2003 64-bit / Vista 64 Bit
• Compact Framework 2.0 - for Windows Mobile 5.0 Pocket PC & Smartphone Editions
• Mono 1.2.x - for Linux, Mac OS X, Solaris, Free/Open/NetBSD