What's new in VistaDB 3?
|
-
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 |
 |
|
 |
|
Improved! ASP.NET and WinForms for Windows
Build
fully managed and typesafe ASP.NET and WinForms 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. Version 3.3 now includes a fully managed MembershipProvider (with source code). |
| |
|
|
 |
|
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
The same VistaDB
assembly for .NET 2 runs unchanged on Mono. Build fully managed and
typesafe cross-platform database applications for Windows, Linux, Mac OS X, Sun
Solaris and BSD operating systems with VistaDB and the Mono Framework. We run all our NUnit tests with the command line test runner under Mono 1.2.x. |
| |
|
|
 |
|
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.
Screenshots |
| |
|
|
 |
|
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.
Screenshots |
| |
|
|
 |
|
Improved! Visual Studio 2005 Server Explorer
support
VistaDB 3 is integrated tightly into the Visual Studio 2005
IDE. Support for Visual Studio's Server Explorer means you can connect to and
use VistaDB databases as you would SQL Server. Version 3.2 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.
Screenshots
|
| |
|
|
 |
|
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.
Screenshots |
| |
|
|
 |
|
Data Builder provides visual data
management
VistaDB Data Builder 3.2 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 WinForms application developed
using VistaDB 3 and C#. The Data Builder source code is
available in all editions except the trial..
Screenshots |
| |
|
|
 |
|
Managed CLR Procs and CLR Triggers
CLR Procs
let you create and store managed proedures using C# or VB.NET into assemblies
that can be registed 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.
Screenshots |
| |
|
|
 |
|
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.
Screenshots |
| |
|
|
 |
|
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 Primarky 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!
Learn more... |
Other Features
- Less than 1 MB footprint.
Single fully managed assembly includes database engine, T-SQL compatible query
processor, Direct Data Access™ objects and ADO.NET Data Provider
- Improved! Engine and data
store changes to take full advantage of .NET's Common Language Runtime (CLR) and
Garbage Collector (GC), including new memory management routines utilizing WMI.
- V-SQL query processor is
highly compatible with Microsoft SQL Server T-SQL syntax
- ZeroClick™ deployment
using
Microsoft's ILMerge utility to fully embed the VistaDB
assembly into your EXE or DLL. Using XCopy or FTP does not require access to
the registry, Windows folder or GAC on client machines
- VistaDB Data Types are now 1:1
compatible with SQL Server 2005 (not all SQL Server 2005 types are present in VistaDB 3 yet)
- Improved! Deep integration into the
Visual Studio 2005 / 2008 IDE's with new integrated support for Server Explorer (even under Windows x64 platforms). Users can now create and alter databases and tables within Visual Studio.
- Allow Partially Trusted
Callers attribute support for ASP.NET
- Isolated Storage support
allows your ASP.NET applications to manage databases locally.
- Unicode support (NChar,
NText and NVarChar support)
- Connection Pooling is now
built into the core engine and provides enhanced performance especially in
ASP.NET applications
- 100% variable length data
store architecture for .VDB3 database files
- CLR Procs let you
write managed C# and Visual Basic .NET procedures to provide powerful data
management and programming. CLR Procs are more powerful than classic TSQL based Stored
Procedures
- CLR Triggers let you write managed trigger code for powerful data validation logic.
- Support for SQL Views
- Fully managed Data Builder
tool allows developers to visually create and manage databases (Visual C#
source code is included). New support for reverse engineering databases to
create SQL scripts and support for viewing Query Plans.
- Fully managed Data
Migration Wizard migrates existing databases to VistaDB database format (Visual
C# source code is included in licensed versions)
- XML import / export support now compatible
with Microsoft SQL Server 2005
- Supports Windows Mobile 5.0
for Pocket PC (via CF 2.0)
- Supports Windows Mobile 5.0
for Smartphone (via CF 2.0)
- Optimized low-level data
encoding engine supports both ANSI and UTF8
- Full support for
ADO.NET 2.0 and all databound controls
- Managed Direct Data
Access™ objects provide high-speed scrollable and updateable cursors for
managing data tables
- Data storage
architecture delivers a smaller database footprint
- Secure Blowfish
encryption
- Full Text Search for CONTAINS operations. FTS indexes are included with the primary database and automatically updated by the database engine - no need to rebuild or manage the full text indexes.
- Data store supports 4TB of data, 64,000 tables, and 4GB of
data per row
- Native 64 bit execution on Windows x64 platforms
- No CPU or RAM limitations
- Optional Source Code Edition allows full access to the database engine for customization
- Annual subscription gives you access to development and stable builds
- Royalty free distribution, there is no charge to ship your product based on VistaDB 3.
|
Purchase |
Products |
Downloads |
Forums |
Blog |
Free Trial
Whitepaper