db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Myrna van Lunteren" <m.v.lunte...@gmail.com>
Subject Re: how to make create script from existing database?
Date Tue, 12 Sep 2006 12:59:59 GMT
On 9/11/06, Michael McCutcheon <michaelm001@frontiernet.net> wrote:
> I'm using the CREATE TABLES feature of toplink/netbeans with the JPA.
> Basically it generates the tables from your entity classes.
> What I would like to do then is generate a database creation script
> from the generated tables that shows the create table/constraints, etc.
> This is so that I can reproduce everything in the schema in another
> database (i.e. dev/test/prod) cleanly.  Also would like to see the
> constraints it is generating, etc.
> Is there a way to do this with derby?
> thanks,
> Mike
Have you looked at the dblook tool? See Derby Tools and Utilities
Guide, http://db.apache.org/derby/manuals/index.html#docs_10.1,
especially http://db.apache.org/derby/docs/10.1/tools/ctoolsdblook.html


View raw message