The following is a partial list of new features for VistaDB 3 from our previous product VistaDB 2.x. This is not a complete list of features, for that visit the features area.
|
ASP.NET Membership Provider, Role Provider and Profile Provider Providers include an ASP.NET wizard to add required tables to existing database, or to modify structures from SQL Server migrated database. |
|
 |
TSQL Procs and User Defined Functions TSQL Procs and UDFs allow you to migrate existing SQL Server procedures to VistaDB with minimal effort. VistaDB is the world's first non Microsoft product to support SQL Server compatible TSQL Procs. There are limitations, and some syntax is not supported. Read the help file for more information. |
| InstallAware setup application generates industry standard MSI based setups and will allow us to obtain a Windows Logo certification later. | |
 |
ASP.NET and Win Forms for Windows Build fully managed and typesafe ASP.NET and Win Forms database applications that run on all .NET platforms. The less than 1 MB footprint of VistaDB's single-file assembly makes it very easy to build and deploy .NET applications for desktops, the web and servers.
|
 |
Fully managed and typesafe C# architecture To maximize integration with the .NET Framework, Compact Framework and Mono, VistaDB 3.x was designed and developed from scratch using C#. The core database engine, the T-SQL compatible query processor, the ADO.NET Data Provider, the Direct Data Access™ objects and the data management tools are all developed in fully managed and typesafe C#. |
 |
Native support for Mono To maximize integration with the .NET Framework, Compact Framework and Mono, VistaDB 3.x was designed and developed from scratch using C#. The core database engine, the T-SQL compatible query processor, the ADO.NET Data Provider, the Direct Data Access™ objects and the data management tools are all developed in fully managed and typesafe C#. |
 |
Embedded support for Compact Framework 2 New embedded support for the Compact Framework lets you build database applications that run entirely on mobile devices. VistaDB 3 eliminates the need to connect to a database server. |
 |
SQL Server 2005 compatible data types and T-SQL syntax VistaDB 3 is highly compatible with SQL Server 2005 data types and supports T-SQL syntax so developers can easily re-use existing code developed for SQL Server 2005 with minimal changes. This new level of compatibility lets developers move between SQL Server and VistaDB with ease. |
 |
Visual Studio 2005 / 2008 Server Explorer support VistaDB 3 is integrated tightly into the Visual Studio 2005 and 2008 IDE. Support for Visual Studio's Server Explorer means you can connect to and use VistaDB databases as you would SQL Server. Version 3.4 now includes the ability to create databases, create and alter tables, indexes and views all within Visual Studio. Direct launch of the Data Builder from within Visual Studio is also now supported. |
 |
Data Migration Wizard The new Data Migration Wizard 3 provides improved support for migrating data from Access and SQL Server. New support for migration scripts lets you define custom rules for migrating data and gives you more control than ever before. Data Migration Wizard was developed in C# and source code is available. |
 |
Data Builder provides visual data management VistaDB Data Builder 3 lets you visually create databases, tables, views, indexes and lets you run interactive V-SQL on your data. This utility is actually a fully managed Win Forms application developed using VistaDB 3 and C#. The Data Builder source code is available in all editions except the trial.. |
 |
Managed CLR Procs and CLR Triggers CLR Procs let you create and store managed procedures using C# or VB.NET into assemblies that can be registered with your VistaDB 3 databases. Once created, you can call your custom CLR Procs from your application to perform various data management tasks. CLR Procs are more powerful than traditional stored procedures since your code has access to the entire .NET framework |
|
|
TSQL Procs and User Defined Functions TSQL Procs and UDFs allow you to migrate existing SQL Server procedures to VistaDB with minimal effort. VistaDB is the world's first non Microsoft product to support SQL Server compatible TSQL Procs. There are limitations, and some syntax is not supported. Read the help file for more information. |
 |
Support for Views VistaDB 3 provides full support for Views. You can write SQL statements to create virtual views of data from one or more tables. With this feature, 3 now supports a full migration of the ubiquitous Northwind database. |
 |
Primary Key and Foreign Key support Relational databases allow data to be stored in normalized order so as to avoid storing redundent information. Support for Primary Key and Foreign indexes lets you define well-designed databases. |
 |
Analysis of VistaDB 3 architecture Microsoft MVP Ralf Westphal digs deep into the VistaDB 3 architecture using Lattix LDM to provide a technical analysis of the VistaDB architecture. Ralf even compares the quality of VistaDB's architecture to the .NET 2.0 Framework itself. Over 400 VistaDB 3 classes get scrutinized! |