db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Damian Carey" <jami...@gmail.com>
Subject Re: Derby SQL diff tool suggestions
Date Fri, 09 Jan 2009 01:27:18 GMT
On Fri, Jan 9, 2009 at 11:55 AM, Thomas Kellerer <spam_eater@gmx.net> wrote:
> Damian Carey wrote on 09.01.2009 01:31:
>
>> I've previously used a Postgres tool called AGPDIFF that takes two
>> (postgres) schemas and creates an "SQL Update Script" to update a
>> database in-situ to a new schema.
>> AGPDIFF  is a single jar file that you use via the command line. It is
>> not perfect, but it does get me plenty close enough to finish by hand,
>> so it is perfect for our needs.
>
> You might want to try my SQL Workbench. It has a diff command built in that
> can also be run from within a batch file (command line).
>
> The output of the diff is an XML file that can be converted to SQL. I do not
> have an XSLT to transform the output into Derby syntax, but Postgres and
> Oracle are available.
>
>
> Regards
> Thomas

Thomas,
SQL Workbench looks like an excellent tool going forward!
I've been trying it out and got it going in minutes.

Just for now, however, I'm looking for a Derby SQL diff tool.

Many thanks for your input!
-Cheers,
-Damian

Mime
View raw message