database:convert_from_bde_to_sqlite
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| database:convert_from_bde_to_sqlite [2017/09/04 19:26] – [Downgrade of 9.8 to 9.7] 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 ====== | ====== 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, | ||
| ===== The conversion process ===== | ===== 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 | - Creation of the patient index | ||
| - Conversion of the patient datasets | - 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] + " | * 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] + " | ||
| - | * 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 |
| * Datasets already converted to version 9.8 should be removed from the copy to avoid confusion. | * 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. | * 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. | ||
database/convert_from_bde_to_sqlite.1504553195.txt.gz · Last modified: 2017/09/04 18:26 (external edit)