VistaDB Software, Inc.

VistaDB 3 is fully compatible with ADO.NET 2.0 which allows VistaDB to be tightly integrated into the Visual Studio 2005 and 2008 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 CE.  Building typed datasets is exactly the same as what you are already used to doing today.

VistaDB 3 Data Builder lets you visually create databases, tables and run interactive SQL.

The ability to visual create data tables, foreign keys, enter data into your database and scroll through tables makes this a great DBA tool for most desktop database applications. 

We give an unbranded version of this DBA tool with complete C# source code for you to use as a quick and powerful DBA tool for your users.

The SQL Editor can read a VistaDB database to generate the corresponding TSQL 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.

This allows you to build your tables graphically and then get the script code to build them programmatically later in your application.

You can use Data Builder to view data directly and optionally specify indexes and filter and scope expressions for application to the current view of the data.  This provides a quick way to build DDA filter and scope expressions and test them against live data.

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

Views are also able to be walked like a normal table using the Data view.

Instantly see the results of a View by clicking on the Data treelist item.  This data is scrollable and provides a quick way to validate your SQL View is returning the desired results.

You can visually manage Foreign Key Relationships using Data Builder.  The view here shows all the relationships for the database.  Each table also shows only the relationships that apply to it directly.

The included Data Builder 3 application provides full support for displaying image and other non text data right inside the results pane.

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.

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 build indexes.