Documentation:VistaDB: Difference between revisions

VistaDB

Latest revision as of 15:49, 10 February 2024

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 rather continue to work with SQLCompactDB (since you will be on Windows) you can do so by deleting the files in red and restart 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.

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

@@ Line 1: / Line 1: @@
-VistaDB is a an embedded db licensed from [https://vistadb.com/ Gibraltar software]
+VistaDB is an embedded DB licensed from [https://vistadb.com/ 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.
+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.
-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 you rather continue to work with SQLCompactDB (since you will be on Windows) you can do so by deleting the files in red and restart the server:
-[[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.
+[[File:2024-02-05 11h19 12.png|none|thumb]]
-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)
+''Internal note to Builders:'' The VistaDB's Nuget package is not public. You need to add the path in VS: C:\capableobjectswush\Xternal\VistaDB
+[[File:2021-04-25 16h20 43.png|none|thumb|659x659px]]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.
-==== Go back to DatabaseCompact when needed ====
+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).
-In MDrivenServer/App_Data
-# Delete/rename the current db DatabaseVistaDB.vdb6  to make it not seen.
+=== Go Back to DatabaseCompact When Needed ===
-# Rename the file UseVistaDBIfThisFileExists to make it not seen.
+In MDrivenServer/App_Data:
-# Restart server.
+# Delete/rename the current DB DatabaseVistaDB.vdb6  to conceal it.
+# Rename the file "UseVistaDBIfThisFileExists" to hide it.
+# Restart the server.
 [[Category:MDriven Server]]
+{{Edited|July|12|2024}}