From: | David Fetter <david(at)fetter(dot)org> |
---|---|
To: | Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> |
Cc: | pgsql-general(at)postgresql(dot)org, Csaba Együd <csegyud(at)gmail(dot)com> |
Subject: | Re: Database schema & data synchronizer software for PostgreSQL? |
Date: | 2009-01-21 04:08:56 |
Message-ID: | 20090121040856.GB13964@fetter.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate
From | Date | Subject | |
---|---|---|---|
Next Message | Együd Csaba | 2009-01-21 04:18:57 | Re: Database schema & data synchronizer software for PostgreSQL? |
Previous Message | Robert Treat | 2009-01-21 03:05:20 | Re: Is this on the to-do list? |