Hi Hank, The URL for the HSQLDB to H2 tutorial is -
http://www.oooforum.org/forum/viewtopic.phtml?p=365296#365296 As you will see, I had asked a series of questions and dacm kindly came up with a very comprehensive set of answers. The steps he listed worked well for me. One point to watch when migrating each table. For Table name enter - <Database name>.PUBLIC.<Table name> e.g. ROSTERS.PUBLIC.Availability I think you can choose an alternative to PUBLIC, but I just went with the default. Regards, Noel -- Noel Lodge lodg...@gmail.com On 28 January 2013 04:15, Hank Alper <hankal...@gmail.com> wrote: > Hi Noel, > Thank you for pointing me to H2. It appears to offer so many advantages > over the embedded HSQLDB in LO Base that I shall certainly spend some time > examining > its possibilities. I'd definitely like to see the tutorial for replacing > HSQLDB with H2. > Hank > > > On Sun, Jan 27, 2013 at 4:36 AM, Marion & Noel Lodge <lodg...@gmail.com>wrote: > >> Hi Hank, >> >> I haven't been following this thread closely, but it seem like you are >> experiencing some of the same problems I had using Base HSQLDB. I >> eventually decided to move my Accounting Project to the H2 Database >> Engine, >> (see http://www.h2database.com/html/main.html). >> >> Some of the many advantages of H2 are - >> - Separate files for Data and Project >> - Can be run in single or multi-user mode >> - Users report successfully running very large databases >> - An active users forum >> >> I have found H2 to be very stable and have not regretted making the >> change. >> If you are interested at all, I can point you to a very good tutorial for >> replacing HSQLDB with H2. >> >> This may not be what you are looking for, but it's probably worth your >> while at least having a look at what H2 has to offer. >> >> Noel >> -- >> Noel Lodge >> lodg...@gmail.com >> >> >> On 27 January 2013 17:24, Hank Alper <hankal...@gmail.com> wrote: >> >> > Hi Alex, Mark, Tom, >> > You guys scare me ! I'm beginning to think I'd better start looking >> for a >> > new back end. I've put a lot of work into this project. Tom, this is >> not a >> > small database like an address book. After normalizing, my design has 16 >> > tables.( with a few more coming as I've discovered as I feed more data >> > into it.) If I connect to an external server is there any way I can >> save my >> > forms and reports? Or shall I have to start anew ? My tables, queries >> and >> > views were all produced using SQL and I have text copies of all of >> them to >> > feed any server I might select. Transfer of data becomes a problem, of >> > course. >> > Hank >> > >> > On Mon, Jan 21, 2013 at 10:36 AM, Alexander Thurgood < >> > alex.thurg...@gmail.com> wrote: >> > >> > > Le 21/01/13 16:01, Mark Stanton a écrit : >> > > >> > > > Isn't hsqldb *still* a (relatively) good choice, as long as it is >> > > installed and >> > > > used *external* to Base? That does of course mean it's still not >> the >> > > "default" >> > > > setting. >> > > >> > > As I mentioned in my answer to Tom, if you use an external version of >> > > hsqldb, it can only be the same version number as the internal version >> > > provided with LO, else the old ODB files can no longer be opened. In >> > > other words, you can not install an external hsqldb jar and expect >> your >> > > old ODB(hsqldb) files to keep working, as this will throw an error. >> > > >> > > So yes, it still remains a possibility, but one that you may want to >> > > avoid if you still have old ODB files that use the internal hsqldb >> with >> > > an older revision number than the externa jar you plug into LO. >> > > >> > > Alex >> > > >> > > >> > > >> > > -- >> > > For unsubscribe instructions e-mail to: >> > users+h...@global.libreoffice.org >> > > Problems? >> > > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ >> > > Posting guidelines + more: >> http://wiki.documentfoundation.org/Netiquette >> > > List archive: http://listarchives.libreoffice.org/global/users/ >> > > All messages sent to this list will be publicly archived and cannot be >> > > deleted >> > > >> > > >> > >> > -- >> > For unsubscribe instructions e-mail to: >> users+h...@global.libreoffice.org >> > Problems? >> > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ >> > Posting guidelines + more: >> http://wiki.documentfoundation.org/Netiquette >> > List archive: http://listarchives.libreoffice.org/global/users/ >> > All messages sent to this list will be publicly archived and cannot be >> > deleted >> > >> > >> >> -- >> For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org >> Problems? >> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ >> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette >> List archive: http://listarchives.libreoffice.org/global/users/ >> All messages sent to this list will be publicly archived and cannot be >> deleted >> >> > -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted