On Fri, Jan 9, 2009 at 11:55 AM, Thomas Kellerer <[email protected]> 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
