Derby offers more reliable transaction persistence and recovery than H2, due to its use of a transaction log for durability even after system failures. While H2 can be faster in some embedded scenarios, Derby’s maturity, proven deployments, and strong adherence to SQL and JDBC standards provide a more stable and feature-rich embedded and client-server solution for Java applications.
Migrate or Reset Database:
You can either migrate database or reset database. Both processes are non-destructive to your original source database.
Reset database: This is for users whom have all hand histories present in their drives. Prior database will simply be left alone and a new DERBY database will be created and fed with scanned hands found in folders as usual.
Migrate Database: This is for specific users who no longer have hand history files present and source H2 database is the only source of hands. This requires extra RAM, hard disk space and time, so be sure to perform this step when not playing or using your SharkScope Desktop.
