Derby database to sql script

Question

Is it possible to get a structure of a derby database so it is saved in a form of an sql script that I can run and it would recreate the database along with the data in it?

Bryan Pendleton · Accepted Answer · 2012-02-15 14:36:51Z

3

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/

edited Feb 15, 2012 at 14:36

answered Feb 14, 2012 at 17:36

Bryan Pendleton

16.4k3 gold badges35 silver badges58 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Derby database to sql script

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related