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.186 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=sop97YEN28rJW6rlw6fBCgBO+Zw3ZhoEN54Ei7IHDmaqadDHQ+h/ETzqyiKNRE1liH
         KNMxgyi9SbNVaK+NdTQTosfVERHQBL2JqCFISfxi3G8BcpXMoTxWO2nNxoSLzkZMYbU3
         i4hcUkRFBBS34HJSnJf6Rz9P21p/Yqq/2IVUU=
Message-ID: <2bbc8f530901091228v7fefd775n94cdef4bf4ac636c@mail.gmail.com>
Date: Sat, 10 Jan 2009 07:28:51 +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: <8F798BFDA851B943B3A1B2510E9287850A6927EB@airmail>
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>
	 <2bbc8f530901082021o3b552a28v6d124114dad59721@mail.gmail.com>
	 <8F798BFDA851B943B3A1B2510E9287850A6927EB@airmail>

On Sat, Jan 10, 2009 at 2:36 AM, Scott Anderson <sanderson@airvana.com> wrote:
> Have you considered using an ORM such as Hibernate or Cayenne to
> alleviate your SQL woes? Cayenne has a Database Merger package which
> could be just what you're looking for.
>

Hi Scott,

Our product is already Hibernate base - which allows us to get a fair
distance with Java skills and with moderate SQL skills.
We use Hibernate to create our schemas. So we have (say) a
"Version7Schema" and a "Version8Schema" - both created by Hibernate.

However, Hibernate does not have a "production quality" method of
updating a database schema. They (Hibernate) do not recommend updating
a schema on live/important data with their tool. So we should not and
do not use Hibernate to update our databases in the field.

Instead we create our update scripts here in the office - where we
modify and test them to make sure they are OK.

Our issue (and our search for a useful Derby "diff" tool) is in
developing the update script that will take us from "Version7Schema"
to "Version8Schema".  We have a tool to do it for Postrges (APGDIFF),
and I was just researching to see if there is something equivalent to
do that in Derby.

Thanks for your interest.
-Damian


> -----Original Message-----
> From: Damian Carey [mailto:jamianb@gmail.com]
> Sent: Thursday, January 08, 2009 11:21 PM
> To: Derby Discussion
> Subject: Re: Derby SQL diff tool suggestions
>
> ...
> 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
>