Re: Need Tool to sync databases with 8.3.1

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Need Tool to sync databases with 8.3.1
Date: 2008-06-15 14:36:03
Message-ID: g339ci$240$1@ger.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

D. Dante Lorenso wrote on 15.06.2008 01:00:
> I need a tool that will compare 2 database schemas and allow me to
> migrate changes from one database to another. What tools do the rest of
> you use to accomplish this task?

You can try my SQL Workbench/J:.
http://www.sql-workbench.net/manual/wb-commands.html#command-schema-diff

It writes out the differences as an XML file.

I have sample XSLT transformations to create SQL statements out of that XML on
my homepage as well: http://www.sql-workbench.net/xslt.html

Regards
Thomas

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2008-06-15 16:49:45 Re: XML output & multiple SELECT queries
Previous Message Julius Tuskenis 2008-06-15 10:57:20 Re: why sequential scan is used on indexed column ???