Am 20.04.2012 14:08, Mark Stanton wrote:
Hi Ian,
The easy version is :-
1) Open your database with the HSQLDB embedded data.
2) In a separate window, create a new database with any other kind of
data engine.
3) Drag the tables from the embedded database to the new database,
one by one.
4) Drag any other objects from the old database to the new one, too.
I'm guessing that the important bit that you need there is missed
out, the "how to create and link up to A.N.Other database".
Indeed, this is the easy version to copy anything (spreadsheet, csv,
mail address, embedded HSQL, ...) into some writable target database.
This can not convert an embedded HSQLDB to an external one because once
you point the office to the external HSQL the embedded won't be
accessible anymore. I described how to extract the whole embedded thing
out of the database.odb and use it directly with the external database.
For the above outlined copy&paste method I use to recommend that you
should have prepared the target database.
Copying the structure and data in one go, as offered by the import
wizard, never creates any auto-ID fields. The wizard can automatically
add some integer key, but it is not the automatically incrementing one
you need in most cases. Once the tables are filled with data it is
difficult (impossible?) to change the primary key to be auto-incrementing.
However, if the auto-id is predefined you can import arbitrary integer
data that fit to the related integers in other tables.
First create all the tables with default values, indices, primary keys,
constraints and foreign keys (relations). Then copy over the raw data
into the prepared structure and in the right order. Detail tables first,
then the dependent data tables where the foreign keys refer to the
detail tables.
--
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.