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 Server Compact.  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 and run interactive SQL. Full C# source to Data Builder is included with non-trial editions.

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 allow redistribution of this tool with your application for a quick and powerful DBA tool for your users.

The SQL Editor can reverse engineer 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 using DDA 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.

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.

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.

The CLR Proc assemblies are loaded into the database to avoid reference problems at runtime.  You only have to xcopy your database and the CLR Procs are copied with the 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 build indexes.

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.

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.