[h2] Re: What's the recommended way to migrate from H2 1.3.175 to 1.4.195

Hendrik, I've answered your question in detail on StackOverflow. On Friday, 5 May 2017 17:29:02 UTC+2, hendrik wrote: > > Hey there, > > asked this on Stackoverflow > > > the other

[h2] Re: What's the recommended way to migrate from H2 1.3.175 to 1.4.195

Regular backups in order to recover from data corruption. Always a good practice. Useful as I had a production db 24/7 for almost 1 year (using 1.3.176) and Windows updates made the database crash a few times. As for the txt done by the recover, I guess it's just a debug log of the recovery

[h2] Re: What's the recommended way to migrate from H2 1.3.175 to 1.4.195

On Monday, May 8, 2017 at 2:02:04 PM UTC+2, Christian MICHON wrote: > > Yes you can use the 1.4 jar to export the script. I've done this already. > > I would advice to use the default settings per version. 1.3 uses page > store, 1.4 the newer store. Do not tweak the defaults settings except

[h2] Re: What's the recommended way to migrate from H2 1.3.175 to 1.4.195

Hi Yes you can use the 1.4 jar to export the script. I've done this already. I would advice to use the default settings per version. 1.3 uses page store, 1.4 the newer store. Do not tweak the defaults settings except the cache size. Try to keep also regular backups using SCRIPT TO. Good

[h2] Re: What's the recommended way to migrate from H2 1.3.175 to 1.4.195

Thanks, Christian. Can I create the script dump with the 1.4.195 version using ;mv_store=false in the connection URL? Or do I *must* I use the 1.3 jar? I guess my question is, did the PageStore format change at all between 1.3 and 1.4? I assume the new database will be MVStore-based, unless I