Differences

This shows you the differences between two versions of the page.

--- database:convert_from_bde_to_sqlite [2017/09/04 19:25] – [Database folder structure] cmenz
+++ database:convert_from_bde_to_sqlite [Unknown date] (current) – external edit (Unknown date) 127.0.0.1
@@ Line 1: / Line 1: @@
 ====== Convert from BDE to SQLite ======
+With coDiagnostiX 9.8, the storage system used for patient data has changed.
+Why we did this:
+  - Ready for data generated by current technology
+  - Foundation for future developments
+  - The new database is easier to maintain
+  - Less prone to harmful user interventions
+  - No interference with 3rd party software
+However, to profit from the benefits of the new database system, all patients from the 9.7 database need to be moved to the new system. Generally, this process does not require any user intervention. However, in some circumstances, questions may arise. This article is intended to answer these questions.
 ===== The conversion process =====
+Converting an old database into the new structure happens without requiring user intervention. The process can be separated into two phases:
-Converting an old database into the new structure can be separated into two phases:
   - Creation of the patient index
   - Conversion of the patient datasets
@@ Line 77: / Line 89: @@
   * When updating to version 9.8, the database path of version 9.7 is changed to a new, not existing database path. Name: [database path] + "97". When version 9.7 is started, it will create a new, empty database in that folder.
-  * Using the BDE database in the legacy folder inside of a converted database with a parallel installation of 9.7 is not recommended. Instead, the old database should be copied.
+  * Using the BDE database in the legacy folder inside of a converted database with a parallel installation of 9.7 is not recommended. Instead, the old database should be copied **before** the conversion.
   * Datasets already converted to version 9.8 should be removed from the copy to avoid confusion.
   * Having an SQLite (9.8 and newer) and a BDE (9.7 and older) in the same directory should not be a problem. Version 9.8 will first try to find a SQLite database in that directory and open it. A BDE database is only opened and converted if no SQLite database can be found.
-===== Downgrade of 9.8 to 9.7 =====
+===== Downgrade of a 9.8 database to 9.7 =====
+Not possible.