On Tuesday 20 January 2009 10:44:06 David Fetter wrote:
> On Tue, Jan 20, 2009 at 03:03:33PM +0100, Csaba Együd wrote:
> > Hi,
> > I'd like to ask your suggestions about a reliable admin software
> > which is able to compare two dabases and generate a schema
> > synchrinizer script.
>
> There is no such thing, and there is no prospect of there ever being
> such a thing, because the database does not contain enough information
> to create this automatically. The problem exists at the
> organizational level, and needs to be solved there.
>
While I would agree that these tools can't solve organizational problems, they
do exist:
http://pgdiff.sourceforge.net/http://apgdiff.sourceforge.net/http://www.dbsolo.com/http://sqlmanager.net/en/products/postgresql/dbcomparer
there are others too...
--
Robert Treat
Conjecture: http://www.xzilla.net
Consulting: http://www.omniti.com