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

Am 14.04.2012 04:22, avamk wrote:
Thank you for all of your replies, the information is very helpful, and I
will continue to explore.

Just one more question: Would migrating to other databases (like MySQL or
PostgreSQL) be similar to how I would migrate from an *.odb file to a HSQL
database? If not, are there instructions for transitioning to MySQL or

No, because you start with a working database structure before you connect your Base document to it. Even if you can edit tables, fields and relations of a foreign database, you can't create such a database newly from scratch and you should abstain from editing tables, fields, indices and relations of a foreign database. Always use dedicated software for the respective type of database engine. Having some Base connection to some source database (including spreadsheets, text etc) and another connection to a target database, you can always copy the raw data from source database to the _prepared_tables_ of the target database. Spreadsheet ranges can be copied directly. But you should abstain from the feature which allows you to create clipboard tables from scratch. This is another big trouble maker among all the useless Base features. The copy&paste between databases is very useful but you should always append new rows to prepared tables. There are a lot more obsolete Base features which cause more trouble than convenience. Most of the Base component which had been added to OOo v2 could be removed without losing the capability to connect, query, report and use input forms.

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.