Re: Need Tool to sync databases with 8.3.1 - Mailing list pgsql-general

From Thomas Kellerer
Subject Re: Need Tool to sync databases with 8.3.1
Date
Msg-id g339ci$240$1@ger.gmane.org
Whole thread Raw
In response to Need Tool to sync databases with 8.3.1  ("D. Dante Lorenso" <dante@larkspark.com>)
List 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

pgsql-general by date:

Previous
From: Julius Tuskenis
Date:
Subject: Re: why sequential scan is used on indexed column ???
Next
From: Peter Eisentraut
Date:
Subject: Re: XML output & multiple SELECT queries