db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ari Maniatis (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DERBY-1851) Create full SQL export of Database (including INSERTs)
Date Tue, 18 Dec 2012 00:38:13 GMT

    [ https://issues.apache.org/jira/browse/DERBY-1851?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13534464#comment-13534464

Ari Maniatis commented on DERBY-1851:

Some notes for people finding this issue:

The dblook tool (http://db.apache.org/derby/docs/10.8/tools/ctoolsdblook.html) will get the
structure of the database and export it as a SQL script.

But it doesn't extract the data.

You could perhaps use the backup and restore utilities, but the format of a Derby backup is
not a sql script.

The Apache 'ddlutils' tool can extract and move the data, I believe. See: http://db.apache.org/derby/integrate/db_ddlutils.html
and http://db.apache.org/ddlutils/

(This was copied from http://stackoverflow.com/questions/9275712/derby-database-to-sql-script)
> Create full SQL export of Database (including INSERTs)
> ------------------------------------------------------
>                 Key: DERBY-1851
>                 URL: https://issues.apache.org/jira/browse/DERBY-1851
>             Project: Derby
>          Issue Type: Improvement
>          Components: Tools
>    Affects Versions:
>            Reporter: Alexander Schatten
>            Priority: Minor
> Currently DERBY supports to backup a database (binary) or to create the DDL of the database.
It would be very helpful (as known from hsqldb) if it would be possible to export a full database
including content; i.e., CREATE, ALTER and INSERT statements.
> This is particularly nice for development issues when a schema is often changing...

This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

View raw message