Create an a Database Configuration:
- database = Hypersonic SQL Db
- driver = HSQL Db Memory
- DatabaseName = AxonIvySystemDatabase
Open the SQL query window and execute:
1. `SCRIPT 'c:/temp/myHsqlDbExport.sql'` to export the full system db schema plus its content
2. `DROP SCHEMA PUBLIC CASCADE` removes the default system db after a restart
3. Paste the content of the previously exported SQL file to re-create the old version
Normally you will run into escaping and encoding problems in the last step. A practical solution could be that you only re-import the INSERT statements instead of the whole SCHEMA+DATA to avoid these problems.