On Tue, Jan 20, 2009 at 09:51:25PM -0500, Robert Treat wrote: > 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... There exist tools which can transform an empty database schema into another. They fail at the real life use case of changing a schema that already has data in it because they can't tell a changed column from one that's been dropped and another added, so I stand by my original contention :) Cheers, David. -- David Fetter <david@xxxxxxxxxx> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fetter@xxxxxxxxx Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
