Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (nike.apache.org: domain of jamianb@gmail.com designates
 74.125.44.28 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:date:from:to:subject:mime-version:content-type
         :content-transfer-encoding:content-disposition;
        b=hIrL2gnXzwezTUp1zqQURlMwTxN6HS/3DOWHeWOHU1JTxl5m6pUC1rSCzxVHJAOi9b
         9gWxjk2yud3a183vZjgtMLyEI2Q/a2DPBtm9IKRJanu8PpMTvUf1DEGjGoYDcd8+p8bz
         V40UQK7su0ufS1H1vkRk84/SMwmm+0QVe9f08=
Message-ID: <2bbc8f530812171724v1c726e17m891dd3ed1f9d7f2a@mail.gmail.com>
Date: Thu, 18 Dec 2008 12:24:34 +1100
From: "Damian Carey" <jamianb@gmail.com>
To: derby-user@db.apache.org
Subject: How to get a Derby schema.sql so we can build the next DB?
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi all,

We're long term Java-Desktop-App-via-Hibernate-On-Postgres users
trying to transition to Derby.

When we deploy a new site we want to be able to (1) create the fresh
database then (2) "run" schema.sql to construct the database schema,
prior to (3) running the app and adding the data.

With postgres we extract the schema.sql from an existing database
(using pgAdminIII or whatever) and pump that raw SQL into the new
database. Easy and 100% reliable.

However, with Derby, I'm not sure how to get that SQL level snapshot
of an existing schema that we can use.

I can get the DDL from dblook, but I can't pump in DDL.  I really
don't want to add DdlUtils etc to our distribution.

So
(1) How do you get the raw SQL??
(2) What else would you suggest for transferring a schema from one
DerbyDB to a new fresh DerbyDB?

Any suggestions or advice would be greatly appreciated.

Many thanks,
-Damian