VistaDB

VistaDB is a fully-managed embedded .NET database engine compatible with SQL Server.

We support VistaDB directly in our products! You don't need separate drivers and can immediately connect to your database.

It competes with SQL Server Compact Edition. Its selling points are that its’ fully managed, doesn’t have artificial limitations imposed on the database engine and very easy learning curve. To add support for VistaDB to a standard Microsoft .NET application, just add a reference to the VistaDB assembly. All functionality is built into that DLL. SQL CE is a separate driver installation and therefore outside of control of the application developer.

VistaDB can even use the same stored procedures, views and even CLR procedures as SQL Server. A single DLL needs to be redistributed whether the application is 32- or 64- bit. It will use all CPUs/cores of the system.

All in all, VistaDB is a solid offering for .NET application developers.

Full Convert Standard Full Convert Pro

We support VistaDB directly. No additional drivers are required.

VistaDB data types we support

Integral

bigint, int, smallint, tinyint

Decimal

decimal (numeric), double, float (real), money, smallmoney

Text

char, nchar, ntext, nvarchar (sysname), nvarchar(max), text, varchar, varchar(max)

Binary

binary, bit, timestamp, varbinary

Date/Time

date, datetime, datetime2, datetimeoffset, smalldatetime, time

Large objects

geography, geometry, image, ntext, nvarchar(max), text, varbinary(max), varchar(max), xml

Other

dynamicobject, hierarchyid, sql_variant, table, uniqueidentifier

Export your VistaDB database

It may make sense to migrate your data away from VistaDB. You may want to do it permanently or just need to share your tables with a collague in a different format.

We will copy all your tables with their data and apply indexing and relationships exactly as they are in your current VistaDB database. In a nutshell, you get exactly the same database in another database engine. Each time you run the migration, we will copy all the tables again. Of course, we have a built-in scheduler, so you can run this overnight and have a fresh database copy in the morning.

Take a look at the quick tutorials below to see how it's done using Full Convert.

Export VistaDB to:

Import data into your VistaDB database

If you want to import data on a regular basis and do not want to recreate the whole target database from scratch every time, but rather do tiny targeted sync of only changes since the last run, use Full Convert Pro.

Take a look at the quick tutorials below to see how it's done using Full Convert.

Import data into VistaDB from: