VistaDB

VistaDB

VistaDB is a fully-managed embedded .NET database engine compatible with SQL Server. 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.

Full Convert supports VistaDB database directly.

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 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.

Import data into VistaDB database

Additionally, 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, please use Full Convert Pro or Ultimate.

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