Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index


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 <hankalper@gmail.com>
To: Alexander Thurgood <alex.thurgood@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.thurgood@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+help@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+help@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+help@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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.