Hi Tom, Noel, Dan, Alex and the others were all quite helpful. I'm going to explore some of my options. Noel suggested H2 as a back end and I was impressed with its specs. I downloaded the program and was pleased with the very clear documentation. In Noel's last post he was good enough to point me to a step by step tutorial for replacing embedded HSQLDB with H2. Unfortunately, that server appears to be down the last few days. Nevertheless I was able to get a connection to the H2 backend with JDBC using the H2 documentation. I have run into some syntax and database naming differences which I shall have to clear up. I expect I shall have plenty of questions about Base's behavior as a client. Hank
On Tue, Jan 29, 2013 at 7:06 AM, Tom Davies <[email protected]> wrote: > Hi :) > Sorry about scaring you! Hopefully you have picked up some good ways of > doing this from some of the other threads. > > If the database is not small then there are tons of good back-ends any one > of which would be great to use. I think Postgresql might be the best at > the moment but you might also enjoy using MySql/MariaDb instead and there > are other good ones. > > Hopefully it should be reasonably easy to migrate the tables and doing so > should not affect tables and forms especially if they are built up from > Queries rather than directly from the tables. If they were do directly > refer to the tables then they probably do need a bit of editing but > hopefully nothing too drastic. > > Apols for not replying sooner! I've just been a bit snowed under and > anyway Dan, Alex and others know far more about specifically Base itself so > hopefully someone has been able to give you much better help! > Regards from > tom :) > > > ------------------------------ > *From:* Hank Alper <[email protected]> > *To:* Alexander Thurgood <[email protected]> > *Cc:* [email protected] > *Sent:* Sunday, 27 January 2013, 6:24 > > *Subject:* Re: [libreoffice-users] Re: Base Report Builder > > 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 < > [email protected]> 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+ > [email protected] > > 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: [email protected] > 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: [email protected] 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
