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.
It's very easy to copy existing database tables into your VistaDB database. Just point Full Convert to your source database, select your target and let it copy things over.
Tutorials showing how to copy data from another database into VistaDB:
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.
Tutorials showing how to copy data from VistaDB to another database: