Anyway, I tried an experiment on my own anyway. I did a script to backup my old database then I appended the properties for page store to the url of the old database. It opened up to a totally new and blank database. I logout of the page store experinmental database and thought I could just remove the page store properties and I would be back inside my old database.... but no it wasn't the case. The old database was gone. No tables, no data ... nothing. I also checked the files made and changed during the proccesses of my experiment. When I used the pagestore properties, a xxx.h2.db file existed besides the conventional log and db files of the old database. Anyway, I gave up on the old database and did a 'drop all objects delete files' to finally kill it and decided to use the backup script to populate my old database and move onto the page store mechanism. I think the new page store seems to be cleaner in terms of the files it generates.
This time, I don't see any temp files around while running my newly converted database. It only has a db file and a lock file and there's all...nothing so bulky like the previous old database. I guess H2 would slowly move to the new page store and little by little, ditch the old stage mechanism and finally phase out the old versions. During this transitional phase, I wonder if there's some tools so that users wouldn't end up like me, unknowingly have the old database emptied while attempting the above experiment I did. Maybe from the next release onwards, H2 would detect the page store properties in the url and check if the database is an old one. If it's an old version, it would do some migration. So all users need to do to migrate from the old storage mechanism to the page store mech. would be as simple as appending the page store properties to the url. On Jul 19, 5:41 pm, Thotheolh <[email protected]> wrote: > Hi. How do I convert my conventional h2 databases to the page store > mechanism ? > > Left say I have an existing database already in use for sometime. Do I > simply just add the page store property behind the database url of my > existing database and it would automatically move to page store > mechanism or is that not how it should be ? ... or maybe I need to > create a new database with page store enabled again then copy all the > old data from the existing database and remove the old database to > make way for the new page store database ? --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
