Legolas Woodland wrote:
Jean T. Anderson wrote:
Legolas Woodland wrote:
...
how i can dump a derby database into a sql file for later use?
I mean i dump a database into sql file and give it with my
application to users , they can import it into thier database and
make all structure and date.
...
... project requirement is to supply an sql file with
initial structure and data.
can you suggest any solution to have an sql dump ?
...
In that case, a combination of dblook to generate the DDL and export for
the data might be one approach. Here are a couple references to help:
http://db.apache.org/derby/docs/dev/tools/ctoolsgenddldb.html
http://db.apache.org/derby/docs/dev/tools/rtoolsimport92876.html
A couple other ideas include:
- write a Java application to generate the sql dump in the exact
format you want
- investigate the Apache ddlutils project at
http://db.apache.org/ddlutils/ . It provides tools that dump DDL and
data in an XML format that could then be massaged by other tools. And it
supports Derby.
regards,
-jean
