Issue 58915 - Need HSQL data export
Summary: Need HSQL data export
Status: CLOSED DUPLICATE of issue 59369
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 2.0
Hardware: All All
: P3 Trivial with 1 vote (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2005-12-05 20:19 UTC by grodysk
Modified: 2017-01-23 18:39 UTC (History)
3 users (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description grodysk 2005-12-05 20:19:11 UTC 
In an application that is WWW online (with MySQL), and has an offline 
component (with OOo Base), i need to periodically keep the two databases in 
sync..  I can export the data from MySQL with phpMyAdmin, then run it into the 
OOo base via the SQL tool, but i don't have a way to go the other direction 
(exporting Inserts from the OOo database tool).
Please consider a SaveAs or Export for databases.  (In ANSI SQL please).

Maybe there is a better way i haven't thought of yet, so feel free to come up 
with a better solution.  I have worked with EAI products in the past, and know 
that this is the type of work they do "automatically" for you.

Thanks for any consideration,
Steve
Comment 1 Frank Schönheit 2005-12-06 07:24:15 UTC 
What about the SCRIPT command?
http://hsqldb.org/doc/guide/ch09.html#script-section
Comment 2 Mechtilde 2005-12-06 10:59:24 UTC 
First perhaps a workaround.

you can export all tables to Calc, save as "csv" and then import this with
phpMyAdmin.
Comment 3 marc.neumann 2005-12-07 09:00:08 UTC 
Hi,

A GUI for the script feature Frank mention, would be a easy solution, so I
reassign this enhancement to the User Experience team for evaluating.

Bye Marc
Comment 4 drewjensen.inbox 2005-12-12 07:57:52 UTC 
I don't think the script command will prove to be of help here. As far as I can
see there is no way to limit the output to a given table. When the command is
issued a full dump of the database if performed, all the table definitions,
constraints and inserts for all data, in all tables. Further more there is no
way to use the command with any type of query.

There is no solution that will generate SQL insert commands that I know off, if
you discount creating an export script (macro). However, if once can work with a
formatted text file (a cvs file was mentioned earlier) then the solution is
already in the HSQLDB engine. The use of a text table. You can issue any select
statement and have it save its result set to a text table. Lookup the Create
Table comamnd in the HSQLDB users manual.

I have used this quite successfully to export data from a Base database. Using
this techinque you can easily export all the records from a table or any
selection you need from a standard SQL Select statement. The option is to use an
Insert Into command with a predefined text table. This approach might suit
Steves needs better.

I think it would be well worth while to explore the addition of an export
function into Base, but feel more thought needs to go into the functionality
that would be useful. The requirements stated in the initial filing of the
issue, IMO, can be readily met with the tool as delivered.
Comment 5 oooforum (fr) 2017-01-23 13:44:55 UTC 
Already reported

Workaround with extension

*** This issue has been marked as a duplicate of issue 59369 ***