[libreoffice-users] Re: Problems importing an OO database into LO

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