• 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

VistaDB 3 is fully compatible with ADO.NET 2.0 which allows VistaDB to be tightly integrated into the Visual Studio 2005 IDE. By providing native support for Visual Studio Server Explorer, you can connect to and use VistaDB databases just as you would SQL Server or SQL Server Compact.

Compact Framework 2.0 application running natively on Smartphone and Pocket PC Editions of Windows Mobile 5.0

VistaDB 3 is fully managed and runs natively on Windows Mobile 5.0 Smartphone and Pocket PC Editions. Windows Mobile 5.0 includes the Compact Framework 2.0, which VistaDB 3 supports natively.

This screenshot shows a mobile demo application developed using C# and VistaDB running on the two most popular Windows Mobile PDA devices: Motorola Q (Smartphone) and the Treo 700w (Pocket PC).

VistaDB 3 runs natively on the Compact Framework. Shown here is a Compact Framework application developed using VistaDB 3 running on Windows Pocket PC 2003.

VistaDB 3 provides full support for SQL-99 syntax and is highly compatible with SQL Server's Transact-SQL syntax.

VistaDB 3 includes a fully managed ADO.NET Data Provider that is fully compatible with .NET Framework and Compact Framework databound controls.

VistaDB Data Builder 3 is a fully managed WinForms database management utility developed using managed C#. VistaDB 3. Data Builder lets you visually create databases and run interactive SQL.

Full C# source to Data Builder is included.

The SQL Editor can reverse engineer a VistaDB database to generate the corresponding V-SQL script needed to recreate the database from scratch. Options include selecting the database objects to include in the script and optionally selecting if data is to be included also.

You can use Data Builder to view data directly without SQL and optionally specifying indexes and filter expressions.

Using Data Builder to manage Views. Data Builder displays the SQL that makes up the View along with other key information.

Instantly see the results of a View by clicking on the Data treelist item.

You can even manage relationships using Data Builder.

Data Builder provides full support for displaying image and other non text data right inside the GUI.

Powerful support for CLR Procs™ allow developers to create easy-to-maintain fully managed .NET assemblies using C# or VB.NET. These CLR Procs assemblies can then be registered with a VistaDB database. These assemblies contain CLR Procedures that manage data directly. Think of CLR Procs as the next generation of Managed Stored Procedures, but using powerful C# and VB.NET instead of SQL.

The process of adding a CLR Proc assembly to a VistaDB database is easy with Data Builder. Simply select the .NET assembly that contains your C# or VB.NET code and VistaDB Data Builder does the rest. You can rename the static methods and see all the method signatures and parameter details.

VistaDB allows you to register multiple assemblies that contain CLR Procs to a database.

Data Builder makes it easy to visually create tables. Specify a table name and description to get started. Then add the individual column definitions.

Easily create columns and define column attributes simply by clicking and setting properties. Data Builder even lets you set column captions that can be used by your applications and column descriptions that can help document your database schema.

You can even define advanced data types such as Identity columns that provide efficient auto-increment support for column values. Other attributes include Primary Key settings, Read Only, Encryption, Compression, Full Text Search (FTS) for text columns, and quickly mark indexes for indexing.

VistaDB Data Migration Wizard 3 is a fully managed WinForms database management utility developed using C# and VistaDB 3. Data Migration Wizard lets you visually migrate databases from various data sources including MS-Access and SQL Server.

Full C# source to Data Migration Wizard is included.

Data Migration Wizard supports script-based migration so that you can pre-define how to migrate an existing database to the new VistaDB database format.

As you progress through each step, there are 7 in total, Data Migration Wizard allows you to select which tables, views, indexes, constraints and other objects are to be migrated and it provides granular control over selecting columns and changing data types for the new database.

Data Migration Wizard allows you to update Views with correct SQL-99 syntax and allows dynamic testing of your new Views.

Upon migration, a detailed log is generated that outlines exactly what was migrated.

Finally, the last step allows you to view the new database, save the migration script and save the log file.