Documentation:VistaDB: Difference between revisions

VistaDB

Revision as of 14:23, 17 January 2023

VistaDB is a an embedded db licensed from Gibraltar software

The main use is to be admin and startup db for MDrivenServer. It will replace the SQLCompact db since this does not work on other platforms than Windows.

Internal note to Builders; The VistaDB's nuget package is not public so you need to add path in VS: C:\capableobjectswush\Xternal\VistaDB

If a new MDrivenServer (has no valid admin db) and it sees UseVistaDBIfThisFileExists.xml the file DatabaseVistaDB_TkStartDb.vdb6 it will be copied into DatabaseVistaDB.vdb6 and from that time the MDrivenServer use VistaDB as admin db.

Else 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 make it not seen.
Rename the file UseVistaDBIfThisFileExists to make it not seen.
Restart server.

This page was edited more than 11 months ago on 02/10/2024. What links here

@@ Line 6: / Line 6: @@
 [[File:2021-04-25 16h20 43.png|none|thumb|659x659px]]If a new MDrivenServer (has no valid admin db) and it sees UseVistaDBIfThisFileExists.xml the file DatabaseVistaDB_TkStartDb.vdb6 it will be copied into DatabaseVistaDB.vdb6 and from that time the MDrivenServer use VistaDB as admin db.
-Else DatabaseCompact_TkStartDb.sdf will be copied to DatabaseCompact.sdf and from that point SQLCompact is used as admin db (will not work on core versions)
+Else 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 ====