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

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:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


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.