Hi, I suggest to use SCRIPT TO 'file.sql' to create a SQL script, and then use RUNSCRIPT 'file.sql' using the new version. You could use SCRIPT TO with the old or the new version. If it doesn't work, use the Recover tool.
> So it means the original database should be backuped and deleted and new must > be recreated from scratch (creating new data files)? Yes. > But I too would be very interested in an easier way to update... One that > doesn't require me to use two different h2 jars The Recover tool should be able to do that. Regards, Thomas On Thu, Apr 23, 2009 at 4:08 PM, Lukas Zapletal <[email protected]> wrote: > > Hello, > > I need to upgrade running instance of H2 because we are getting the > "File ID mismatch" exception during startup index creation or some > data operations with tablescans (DELETE FROM ... WHERE > non_index_column). We do need to save all data (or most of them) and I > hope upgrade could help here because this problem is already fixed > according to the changelog. > > Is it ok to just upgrade the JAR file and restart our system? Or is > there some need of upgrading the data format to new storage version to > solve this issue? I cannot find anything about upgrading in the > documentation. > > Thanks > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/h2-database?hl=en -~----------~----~----~----~------~----~------~--~---
