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 <hankal...@gmail.com> >To: Alexander Thurgood <alex.thurg...@gmail.com> >Cc: users@global.libreoffice.org >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 < >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