VistaDB
No edit summary
No edit summary
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
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) 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: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.


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)
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 ====
==== Go Back to DatabaseCompact When Needed ====
In MDrivenServer/App_Data
In MDrivenServer/App_Data:
# Delete/rename the current db DatabaseVistaDB.vdb6  to make it not seen.  
# Delete/rename the current DB DatabaseVistaDB.vdb6  to conceal it.  
# Rename the file UseVistaDBIfThisFileExists to make it not seen.  
# Rename the file "UseVistaDBIfThisFileExists" to hide it.  
# Restart server.
# Restart the server.
[[Category:MDriven Server]]
[[Category:MDriven Server]]

Revision as of 13:13, 8 February 2023

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.

Internal note to Builders: The VistaDB's Nuget package is not public - you need to add the path in VS: C:\capableobjectswush\Xternal\VistaDB

2021-04-25 16h20 43.png

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:

  1. Delete/rename the current DB DatabaseVistaDB.vdb6 to conceal it.
  2. Rename the file "UseVistaDBIfThisFileExists" to hide it.
  3. Restart the server.
This page was edited 99 days ago on 02/10/2024. What links here