VistaDB is an Embedded SQL Database Engine for .Net
VistaDB is the only .Net embedded
database that allows you to Xcopy a single DLL for both 32 and 64 bit runtime support.
Want ClickOnce deployment for your .Net application? VistaDB requires
zero config on the client.
No more worries about COM deployment for the database engine! Even our
database files are built for ease of deployment - a single database file with no
external logs or complex permissions.
Most desktop users of VistaDB don't even know they are using us!
About the VistaDB 4 .Net Database Engine
There are a lot of free database engines out there that you could use for your
projects. But none of them provide the same level of functionality and SQL
Server compatibility of VistaDB. Not even SQL CE can match the features
built into VistaDB. We are the only embedded database that supports SQL
Server compatible T-SQL and CLR Procs.
Database Basics
If a relational database doesn't have advanced features like updatable SQL Views, true referential integrity,
cascading updates / deletes, table value params, T-SQL stored procedures, CLR
Triggers, and
CLR stored procs then why would you bother? Database engines that only
provide lip service to protecting your data, and matching up features you need
are a waste of your time. VistaDB is the most advanced embedded sql desktop database
engine in the world.
Worried about steep learning curves?
Developers who are already familiar
with the SqlClient namespace will feel right at home in VistaDB. We
are also an ADO.NET 2 provider. All of the familiar syntax from ADO.NET
works with VistaDB.
Support VistaDB and SQL Server from the same executable?
Do you wish you could build a single executable that supported both SQL Server
for multi user and another database on the desktop? We know how hard it is
to build applications that support both desktop and client server from a single
executable. VistaDB syntax contains the most commonly used features from
SQL Server. All of our syntax will scale up to SQL Server. This
means you can use one codebase in your product and run it against SQL Server and
VistaDB.
VistaDB fully supports
the ADO.NET Provider Factory model. This allows you to dynamically load
the database engine at runtime based upon application preferences. Many companies use VistaDB
on the desktop and SQL Server for larger deployments. It is not the
easiest way to write database code, and there is much less documenation around
to explain how to do some things in Visual Studio. But if you take the
time using Provider Factories can be a powerful runtime feature for your
application.
Work with Visual Studio?
VistaDB has full Visual Studio integration
giving you the familiar tools you need to be productive quickly, including full Server
Explorer integration. Developers who have used other desktop
databases in Visual Studio will be able to immediately start working with
VistaDB.
Full integration within Visual Studio Standard or Higher
Dot Net Database Admin Tools?
Some embedded databases give you an engine and nothing to edit or maintain the
actual database. You usually have to purchase a third party DBA tool, build you own,
or tell users to go download the large bulky tool from the vendor.
If you want to deploy a custom branded database admin tool to your users, building
your own is often your only choice. VistaDB includes a powerful graphical
dot net database admin tool
for developer usage, and provides an unbranded version with complete C# source
code. The DBA Sample Tool gives you a fully functional tool that you can
brand and ship to your users! Many users tell us how the DBA Tool alone
was worth the purchase price in time savings.
VistaDB Data Builder Screenshot