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
 64.233.170.185 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:date:from:to:subject:in-reply-to:mime-version
         :content-type:content-transfer-encoding:content-disposition
         :references;
        b=LMh7gqvKJbdkHE90+cWo6QM48lzjObvDiOYAWFvbNJ/iAFj3N11zcuRsN8JJuAdbV7
         bpxUHWtMA/MjRb2pqCzWKDGiYcmc1qaW93ICugjHOlTnCubiBe0aNOehHV7A5H2ABAwM
         FyxhbTiPKoNSYNmhqMrgNfXS3HAfb7psNgQ/U=
Message-ID: <2bbc8f530901082021o3b552a28v6d124114dad59721@mail.gmail.com>
Date: Fri, 9 Jan 2009 15:21:12 +1100
From: "Damian Carey" <jamianb@gmail.com>
To: "Derby Discussion" <derby-user@db.apache.org>
Subject: Re: Derby SQL diff tool suggestions
In-Reply-To: <x1oxocyhyvrb.fsf@sun.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <2bbc8f530901081631y39f3ffb2v732b03678961594b@mail.gmail.com>
	 <gk679h$rfu$1@ger.gmane.org>
	 <2bbc8f530901081727p4054ca18xc80b2cbb5e2c1f96@mail.gmail.com>
	 <x1oxocyhyvrb.fsf@sun.com>

On Fri, Jan 9, 2009 at 2:59 PM, Dag H. Wanvik <Dag.Wanvik@sun.com> wrote:
>
> As a possible hack for really basic needs, Derby has a tool called
> dblook whose text output you could possibly diff, maybe after some
> filtering ;-)
>
> Dag

Thanks Dag,
As part of my research for moving from Postgres to Derby I have used
dblook quite a bit to get the schema as DDL, then using (another Derby
tool) "ij" to add the schema to a new derby DB.

That is OK for a new empty database, but I'm more concerned about the
"update existing database" use case. The equivalent Postgres tool
(APGDIFF) takes the two nude schemas and proposes which "ALTER TABLE"
etc commands can be used to migrate the existing database. It is far
from perfect - but it does give a really good start.

My Java skills are 7/10 (an adequate pass), but my SQL skills are 3/10
(I can spell "SQL"), so the tool helps ease the transition. The
products use Hibernate - and that both creates the schema, and writes
all the SQL for us.

Thanks for your reply!
-Damian