Purchase |  Products |  Downloads |  Forums |  Blog |  Free Trial     

2.1 is no longer sold or supported - these pages are for reference purposes only. VistaDB 3.x should be used for all new development.

VistaDB 2.1 Features

See our new VistaDB 3.0 managed SQL database engine for .NET Click here!.


Overall
Database
Components
Tools
Embedded SQL Engine
SQL Server Engine
  • FREE 2-User Edition included with all products!
  • Optional product to manage VistaDB databases remotely
  • Royalty free distribution
  • Small 700KB footprint (200KB EXE + 500KB VistaDB embedded engine)
  • Remote SQL-92 processor (SELECT, INSERT, DELETE etc.)
  • Runs as Windows service or console application
  • Secure high-speed TCP/IP connectivity for LANs and Internet access
  • Server Manager utility

  • Full featured RDBMS

    VistaDB is a full featured Relational Database Management System that provides industry support for SQL-92 and powerful Direct Data Access™ objects for live cursor support. VistaDB includes a robust data store format, tools, components and high-speed embedded and server engines that allows you to create powerful database applications using popular development tools such as Visual Studio 2005, Visual Studio .NET 2003, Delphi, Visual Basic 6 and classic ASP with VBScript.
    • Eliminates configuration issues
    • Easy to deploy
    • Build powerful database applications
    • Plug and play replacement for Jet

  • Small footprint

    The VistaDB embedded engine is only 500KB which is over 40 times smaller than Jet/Access, 100 times smaller than SQL Server Express and is over 150 times smaller than the MSDE

    Learm more
    • Build applications that are magnitudes smaller than SQL or Jet based apps
    • Easily deploy applications over the Internet
    • Requires less resources to run
    • Easier to maintain

  • Royalty free distribution

    Both the VistaDB Embedded and Server editions are royalty free so you can build and deploy your applications without concern for additional costs or complex licensing restrictions.
    • Build applications that are magnitudes smaller than SQL or Jet based apps
    • Deploy smaller applications over the Internet easily
    • Requires less resources to run

  • Easy-to-Use

    It cannot be overstated just how easy-to-use, yet powerful, VistaDB is. The original design goal for VistaDB was

    • Build applications that are magnitudes smaller than SQL or Jet based apps
    • Easily deploy applications over the Internet
    • Requires less resources to run
    • Easier to maintain

  • Copy 'n Go!™ deployment

    XCopy and FTP deployment makes it very easy to deploy your ASP.NET and WinForms applications. Full deployment of a VistaDB .NET application is 700KB making VistaDB ideal for distributing applications over the Internet. Deploying a .NET application consists of copying only 2 VistaDB files to the same directory as your application.
    • Can deploy ASP.NET apps on shared hosts that support ASP.NET
    • Easy deployment that saves time
    • No configuration or administration required
    • No need to access the Registry or GAC
    • Nothing to register on the target machine, which is ideal for ASP.NET developers

  • More robust than Jet/Access .MDB files

    Robust multi-user support and solid network file sharing ensures that multiple users accessing the same database on a network will not corrupt the data, nor will users experience the locking issues that Jet/Access is notorious for.

    Learn more
    • Ensures data integrity and minimizes data loss
    • Provides shared network data access

  • Built for .NET with support for Win32

    VistaDB supports .NET and Win32 natively. The VistaDB ADO.NET Provider supports .NET languages such as C#, VB.NET and Delphi.NET and fully supports the .NET 1.1, NET 2.0 and .NET Compact Frameworks. In addition to support for .NET, VistaDB has native Win32 VCL components for Borland Delphi and C++Builder and features COM objects that can be used by both VB6 and classic ASP. These are provided to bridge the migration period from Win32 to .NET
    • Robust database solution for both Win32 and .NET development
    • Long-term database solution for the NET platform
    • Full compatibility with ADO.NET 1.1 and 2.0
    • Re-use existing .NET code developed for other .NET Providers
    • Re-use existing VCL code developed for TTable or TQuery
    • Build WinForms and ASP.NET applications
    • Compatible with popular 3rd party components under .NET and VCL
    • C# source code included for .NET Provider
    • VCL Delphi source included for VCL components

  • Outstanding value

    VistaDB's broad market appeal allows us to provide aggressive pricing with no additional runtime licensing fees when deploying your applications. Our value pricing keeps your costs in check. You can own VistaDB for less than it costs to buy one regular coffee each week for an entire year!
    • Keeps your costs down
    • Eliminates reason to use Jet
    • Save money on VistaDB to buy other 3rd party components

  • Single-file data store

    All data for a database is stored in a single .VDB data store file. VistaDB database files (.VDB) provides robust storage, full data integrity and simplified application deployment. Applications can open and manage multiple .VDB database files directly, and .VDB files exist in different directories.
    • Easy to manage and easy to deploy data store file using XCopy or FTP
    • Easy to backup

  • Large storage capacity

    Can store up to 4TB of data with over 64,000 tables per database and supports billions of rows per table. You can even store 4GB of data per row and individual Varchar, BLOB and Memo fields can store 4GB of data per row. Over 64,000 columns per table with over 64,000 indexes per table is supported.
    • Virtually no limit to storage
    • BLOB support provides a flexible way to manage any type of data including image and multimedia files

  • Secure encryption and password protection

    Two types of secure encryption are supported: Blowfish and DES. For ultimate security, VistaDB supports encrypting both data and the database structure. A table can be marked for encryption and then the individual columns to be encrypted are specified. Selecting only those columns that need to be encrypted improves performance in tables that have many columns, since the engine does not have to decrypt unnecessary columns. VistaDB also supports basic password protection for databases, with no encryption.
    • Secure your data and database schema
    • Comply with industry standard encryption requirements

  • Rich data types

    Support for BLOB, Boolean, Character, Currency, Date, DateTime, Double, GUID, Int32, Int64, Memo, Picture and Varchar. VistaDB supports NULL values for all these data types. DateTimeStamp data types are supported via "Dynamic Default Values". Identity fields are also supported (auto-increment with seed and step values) on all data types.
    • Store and retrieve any type of data
    • Migrate existing data without converting

  • Full-Text Search (FTS)

    Designed to provide high-speed searching in the contents of Character, Memo, Varchar and BLOB column data. FTS is very useful for both large memo or Varchar data columns and regular Character fields since it indexes individual words. For example, this allows high-speed searching in Character columns that store address information, allowing you to find part of a street name.

    When creating or restructuring a table, specify which columns are to be marked for Full Text Search and VistaDB will maintain a high-speed index for them. Subsequent searches for data in these columns is blazing fast. See Data Builder, under Data for a given table to see FTS in action.
    • High-speed access to your data without additional coding
    • Very easy to configure

  • Primary Keys and Foreign Keys

    A Primary Key index is a list of columns that have been designated to make up the Primary Key for a table. Defining Primary Keys is straightforward. Select a column, or group of columns, in a given table that will produce a unique value within all the rows of your table. The engine will create the Primary Key index and maintain it for you.
    • Granular control over data
    • Row-level locking lets you build flexible multi-user apps
    • No escalation of "Page locks"

  • Dynamic default values

    Use pre-defined functions to set default values for new records dynamically. Functions such as NOW() can be used to set DateTimeStamp values or time stamps dynamically for new records.
    • Flexible method of setting default values for new rows

  • High-speed indexes

    Developers are rewarded with speed when indexes are defined for columns. Indexes Indexes provide very high-speed data access. Indexes can consist of single or multiple columns and can be defined with Case Sensitivity, Descending and Unique attributes. By default, indexes are not case sensitive.
    • Provides very high-speed performance for accessing data
    • Automatically maintained by engine
    • Granular index definitions provide flexible control

  • Triggers

    Set up triggers to execute when various events occur on a table, including: RowInsert, RowDelete, RowUpdate. Each trigger may be set to execute before or after these events occur. You may access and update other tables and columns within a trigger script using V-Script.
    • Reduces coding in your client code
    • Centralizes database logic inside the database
    • Provides high-speed data management

  • Constraints

    Validate data entry. Constraints may be created for individual columns or groups of columns. The same V-Script used in Triggers is used to define Constraints.
    • Ensures better data integrity
    • Reduces coding

  • Relationships

    Define relations between tables using Primary Keys and Foreign Keys. This allows the engine to perform cascading deletes automatically and ensures data integrity.
    • Ensures better data integrity
    • Reduces coding

  • Full referential integrity

    Define how VistaDB manages cascading deletes and updates within the relationships gives your databases full referential integrity.
    • High-end database feature
    • Ensures high level of data integrity

  • ADO.NET Data Provider for .NET 1.1, 2.0 &
    Compact Framework

    The VistaDB Provider is a fully managed ADO.NET Provider that works just like Microsoft's SqlClient SQL Server Provider. VistaDB design-time wizard integrates in to Visual Studio .NET 2003 and Visual Studio 2005 and allows you to visually connect to a database to generate .NET Datasets automatically.

    The VistaDB ADO.NET Data Provider is fully ADO.NET compliant. You can use standard SQL commands to access and manipulate data in VistaDB databases. The VistaDB ADO.NET Provider includes VistaDBDataAdapter, VistaDBCommand, VistaDBConnection and the non-visual VistaDBDataReader .NET components that connect your WinForms and ASP.NET applications to VistaDB databases and integrate tightly into ADO.NET while providing full support for databound .NET controls.
    • Re-use existing code based on SqlClient or other .NET Providers
    • Fully compatible with databound controls including the DataGrid
    • Supports Visual Studio .NET 2003 and Visual Studio 2005, Delphi 2005/2006 and SharpDevelop
    • Full compatibility with .NET 1.1, 2.0 and the Compact Framework

  • OLE DB Provider and COM objects for VB and classic ASP

    VistaDB features an OLE DB Provider and COM objects for Win32 development using VB and classic ASP. Database, Table, Query and Email objects let VB and ASP developers build Win32 and web-based database applications.
    • Full support for ADO/OLE DB compatible controls
    • Easy-to-use database engine
    • Generate small footprint applications using VB or ASP
    • Easy to deploy on desktop, shared network or Internet

  • VCL components for Delphi/C++Builder

    VistaDB features native VCL components for Win32 development using Delphi and C++Builder. TVDBDatabase, TVDBTable, TVDBQuery and TVDBDirect lets developers build Win32 database applications. VistaDB is fully compatible with all data aware VCL controls including TDBGrid and TDBEdits etc.
    • Excellent alternative to Paradox database files
    • TDataset compatibility means full support for data aware controls
    • Native data access without the BDE
    • Generate small footprint applications
    • Full source code included
    • Supports Delphi 5,6,7,2005,2006 and C++Builder 5,6

  • Direct Data Access™ objects (DDA)

    Unique to VistaDB, VistaDBDatabase and VistaDBTable are .NET data objects let you connect directly to the VistaDB database engine and provides object-based, live data cursors into your database for maximum performance and less overhead than ADO.NET. Modeled after ADO.NET DataSet, DDA objects provide a high-speed object-oriented approach to developing .NET database applications.
    • Object-based control over data
    • Less overhead that ADO.NET with more performance

  • Crystal Reports

    Compatible with Crystal Reports for .NET.
    • Build powerful reports for VistaDB database
    • Re-use existing Crystal Reports code with VistaDB

  • ComponentOne

    Compatible with ComponentOne's .NET products including DataObjects, Input, and Reports.
    • Build powerful reports for VistaDB database
    • Re-use existing Crystal Reports code with VistaDB

  • DataDynamics

    Compatible with Data Dynamics popular ActiveReports for NET product.
    • Build powerful reports for VistaDB database
    • Re-use existing ActiveReports code with VistaDB

  • Data Migration Wizard

    Makes it very easy to migrate existing databases from Access, dBASE, FoxPro, SQL Server, ORACLE, Paradox, and more to VistaDB's robust .VDB database format. Full migration of Microsoft's famous Northwind database takes just a few minutes. A BDE edition is available that supports InterBase, dBASE and Paradox.

    See screenshots.
    • Migrate existing databases to VistaDB quickly and easily
    • Start building applications based on VistaDB quickly

  • Data Builder Utility

    Powerful yet easy-to-use application that lets you visually create and manage VistaDB databases (.VDB files). You can create, modify and delete tables, indexes, triggers, constraints, columns, set database encryption, and more. Data Builder also lets you run interactive SQL-92 commands directly on your data.

    See screenshots.
    • Visually create and maintain VistaDB databases easily
    • Run interactive SQL without programming

  • Pack Database Utility

    Lets you easily pack .VDB databases and reclaim disk space from deleted rows, tables, etc. The .VDB structure may occasionally change between releases and this utility makes it easy to update your .VDB databases to new versions by allowing you to pack databases in batch mode and to work on sub-directories. It can also be run from silently from the command line.

    See screenshots.
    • Reclaim disk space
    • Automate database maintenance

  • 3rd Party tools for VistaDB

    Several powerful 3rd Party products are available to help make developing VistaDB database applications even easier. They include dOOdads from MyGeneration, Mere Mortals .NET Framework by Oak Leaf, Opf3 by Christien Liensberger, .VDB Database Analyzer by Vertical Software, and WilsonORMapper by Paul Wilson.
    • Generate bug-free Object Relation mapping code automatically
    • Save time making database objects in code
    • Get up to speed with VistaDB quickly

  • Fast performance

    Using VistaDB's unique Direct Data Access™ objects, VistaDB can traverse a 1 million record table in 9 seconds which is 100,00+ records per second! The VistaDB ADO.NET Provider can insert 6,400 records per second into a database!
    • Provides end-users with quick database queries
    • No need to make big migration up to MSDE

  • SQL-92 query processor

    Built-in SQL query processor supports full range of data manipulation and data definition commands including parameterized queries, nested SELECTs, SELECT (TOP, WHERE, JOIN, CASE, UNION, LIKE, CONTAINS, GROUP BY, ORDER BY, IF, AS, INSERT, DELETE, UPDATE, ALTER, CREATE, DROP, and more with 50+ V-SQL support functions such as Count(), Avg(), Max(), LastIdentity(), Lower(), Upper(), Left(), Right() etc. for detailed data manipulation.
    See: SQL-92 commands.
    • Eliminates learning curve
    • Can re-use existing SQL statements
    • Provides end-users with quick results for database queries

  • Snapshot isolation level Transaction Processing (ACID)

    VistaDB implements a state-of-the art transaction processing (TP) architecture that supports multiple nested transactions. The foundation of VistaDB's TP architecture is a technology called versioned or serializable transactions. This is also referred to as Snapshot isolation. Snapshot isolation eliminates the need for VistaDB to lock tables, rows or database pages when involved in a transaction. There is no concept of "locking rows" when in a transaction using VistaDB's Snapshot isolation level. VistaDB's Snapshot isolation eliminates lock escalation and thereby eliminates deadlock problems.

    Each VistaDB transaction receives its own view of the database when the transaction starts. While in the transaction, modifications are isolated from all other transactions, including nested transactions and transactions from other stations, until the transaction has been committed to the database or rolled back. Rollbacks are in fact effortless and will never jeopardize the integrity of a database, nor will they cause any lock problems. Snapshot isolation is the future of Transaction Processing and is now implemented in the upcoming SQL Server 2005 Express .
    • Eliminates deadlocks and eliminates escalation of Page Locks experienced in SQL Server and MSDE
    • Robust state-of-the-art transaction processing architecture
    • Ensures high level of data integrity
    • This feature is found in high-end databases only
    • Solid Rollback

  • Single and multi-user support

    VistaDB 2.0 is a "file server" type database. VistaDB 2.0 supports single-user and multi-user access to database files.
    • Building desktop or shared network database apps with ease
    • Ability to create great database solutions for small offices
    • Low resource requirements, low overhead and zero configuration

  • SureCommit™

    Unique to VistaDB, SureCommit™ ensures that a VistaDB database is updated with any committed transaction even if a catastrophic event, such as a power outage, occurs in the middle of the update. SureCommit resumes any incomplete updates the next time a database is accessed. SureCommit is not implemented in this release.
    • Robust state-of-the-art transaction processing architecture
    • Ensures high level of data integrity
    • This feature is found in high-end databases only

  • Row and table-level locking

    VistaDB provides full support for concurrency, row-level locking and table-level locking.
    • Granular control over data
    • Row-level locking lets you build flexible multi-user apps
    • No escalation of "Page locks"

  • Automatic storage recycling

    VistaDB automatically recycles rows that have been deleted. The space occupied by deleted tables, rows and all other database entities gets reclaimed and re-allocated.
    • Easily create and maintain VistaDB databases visually
    • Run interactive SQL without programming

  • XML import and export

    Full support for high-speed importing and exporting of VistaDB data, including schema only, data only, or schema plus data. Importing and exporting to comma and space delimited text files is also supported.
    • Flexible method of getting data in and out of VistaDB databases
    • Based on industry standard XML
    • Easy to edit XML code

  • Automatic data synchronization

    When accessing data in local and shared environments, committed changes to a database are automatically detected by all users. Since the DDA objects have live data cursors, applications using DDA benefit greatly from this synchronization.
    • Saves coding time
    • Helps to ensure better data integrity

  • In-memory databases and tables

    VistaDB supports creating and managing in-memory databases and tables as if they were physical files. In-memory tables may be created from existing physical structures, data may be loaded and saved back to physical tables.
    • Provides fast way to manage data in memory

  • Write-behind data caching

    VistaDB's low-level write-behind data caching occurs for row updates, deletes and insert operations to deliver improved data integrity while processing complex actions that require access to several tables and/or indexes simultaneously.
    • Improves data integrity
    • Speeds up data management

  • International support

    Managed at the database level, VistaDB supports multiple collation settings per individual indexes. This per-index collation setting prevents indexes from being corrupted in a shared international user environment where data is accessed by Windows users that run different locales.
    • Ensures better data integrity
    • Reduces index corruption
    • Delivers correct index sorting based on system settings

 VistaDB 2.1 2.1 Editions Other
Home |  Support |  FAQ |  Testimonials |  Site Map |  Contact Us |  News Archives |  Terms  
 © 1999-2008 VistaDB Software, Inc. All rights reserved.