VistaDB is an embedded DB licensed from Gibraltar software.
Its main use is to be an admin and startup DB for MDrivenServer. It will replace the SQLCompact DB since this does not work on platforms other than Windows.
If you would rather continue to work with SQLCompactDB (since you will be on Windows), you can do so by deleting the files in red and restarting the server:
Internal note to Builders: The VistaDB's Nuget package is not public. You need to add the path in VS: C:\capableobjectswush\Xternal\VistaDB
If a new MDrivenServer (has no valid admin DB) sees UseVistaDBIfThisFileExists.xml the file DatabaseVistaDB_TkStartDb.vdb6, it will copy it into DatabaseVistaDB.vdb6. From then on, the MDrivenServer will use VistaDB as the admin DB.
Otherwise, DatabaseCompact_TkStartDb.sdf will be copied to DatabaseCompact.sdf, and from that point, SQLCompact is used as admin DB (will not work on Linux and macOS).
Go Back to DatabaseCompact When Needed
In MDrivenServer/App_Data:
- Delete/rename the current DB DatabaseVistaDB.vdb6 to conceal it.
- Rename the file "UseVistaDBIfThisFileExists" to hide it.
- Restart the server.
SQLite as Admin and build-in database
20260813 we addes SQLite as a built-in-admin-db option. It is started by having this file in your App_Data UseSQLiteIfThisFileExists.xml.
If DatabaseVistaDB.vdb6 is not present (Vista already active) and not DatabaseCompact.sdf is present(SQLCompact already active ) the file Database_TkStartDb.sqlite will be copied to Database.sqlite - and SQLite will be the active built in database for your mdrivenserver.