On 9/11/06, Michael McCutcheon <[EMAIL PROTECTED]> 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
Hth
Myrna
