VistaDB 3 3.5
LIGHTWEIGHT SQL SERVER API ENGINE FOR .NET
VistaDB 3 database engine was developed in C# specifically for Microsoft .NET Framework, Compact Framework and Mono. VistaDB is the perfect embedded alternative to SQL Server. Use our embedded engine for developing small to midsize managed ASP.NET and WinForms applications that run on desktops, mobile devices and web servers. VistaDB 3 delivers high-performance data management in a small single-file footprint. Lightweight deployment means no registry access or service installation required. VistaDB is a true transactional TSQL compliant RDBMS that delivers robust data management. As an embedded database, it requires zero administration and ZeroClick deployment lets you embedded VistaDB directly into your EXE and DLLs using ILMerge. Licensed per developer.
VistaDB is deeply integrated into Visual Studio 2005 and 2008 so building applications is easy and intuitive. VistaDB features a built-in ADO.NET Provider that supports SQL and Direct Data Access objects that provide object-based high-speed scrollable and updateable cursors. VistaDB's SQL query processor supports T-SQL syntax and VistaDB's data types are highly compatible with SQL Server. A high degree of compatibility with SQL Server 2005 means existing T-SQL statements and procs can be re-used with small changes and source code that uses SQL Server can be re-used with minor changes to namespaces and class references.
Other features include a Data Migration Wizard tool that migrates data from MS-Access, SQL Server, SQL CE to VistaDB (C# source code included) and a Data Builder tool for visually creating and managing databases (C# source code included). The robust single-file data store stores ANSI and Unicode data, tables, views, CLR Procs, CLR Triggers, indexes, Full Text Search (FTS), constraints, primary and foreign keys and data can be encrypted at the database, table or column level using Blowfish. Full transaction processing with Snapshot isolation level ensure that VistaDB is ACID compliant.
VistaDB 3.5 released worldwide March 11, 2009. VistaDB 3 is the world's first fully managed and verifiably
typesafe SQL database for Microsoft .NET, Compact Framework and Mono. And with the new improvements to the Server Explorer designer and TSQL compliance syntax VistaDB is the only lightweight alternative to Microsoft SQL Server. Utilizing TSQL Stored Procedures and User Defined Functions in a non Microsoft product is now possible.
Software developers can use VistaDB 3 to build fully managed, cross-platform database
applications that conform strictly to CLR-compliant platforms. The small less than 1 MB footprint can be
fully embedded into WinForms and ASP.NET applications and can be deployed royalty-free.
VistaDB 3 lets developers build single and multi-user database applications for desktops,
mobile devices and web servers. Databases can run from readonly media, network drives, isolated storage and more.
VistaDB 3 Key Features include:
- Truly embedded SQL database for .NET, Compact Framework and Mono
- Small < 1 MB footprint
- ASP.NET Memebership, Role, and Profile Providers
- 100% managed and verfiably typesafe architecture developed in C#
- 1:1 SQL Server 2005 compatible data types and T-SQL query syntax support
- Full Visual Studio 2005 and 2008 integration with Server Explorer
- TSQL Stored Procedures and User Defined Functions
- CLR Procs and CLR Triggers
- Royalty free distribution!
- XCopy deployment of database and runtime engine
- Visual Studio 2005 / 2008 Designers
- Templates for adding databases to your projects
- User Interface changes for most recently used options
- Winforms DBASampleTool - new sample is an unbranded version of the Data Builder that may be used as a starting point to create a DBA tool for your application. The distribution of this project is covered as a part of all registered users subscription, there is no additional cost. All of the source needed to build the app is included with full licensed installs (not trials or Express builds).
- Winforms Provider Factory - Sample of consuming a provider factory in a dll, but still loading the factory through an app.config.
What is new in 3.5 software version? - VistaDB 3.5 includes updated tools and new templates for Visual Studio 2005/2008. A newly redesigned Data Builder, and a sample DBA Admin tool with source you can customize for your product. Over 40 changes for TSQL syntax parsing to be more compliant with SQL Server 2005.. What is expected in the future? Newly-made VistaDB 3 3.6 be downloaded from current page, we also looking forward to unconfirmed 3.7 release build. You may download download-evals.asp directly, estimated download time by ADSL or EDGE [~1.8 Mbit/s] is 0:00:58. Just write the reviews of the VistaDB 3. System requirements are .NET 2+, Visual Studio 2005/2008. Program has been scanned and verified by the several antivirus and anti-spyware applications and VistaDB 3 found to be clean. The following languages are supported by VistaDB 3: English.
