Skip site navigation (1) Skip section navigation (2)

Re: Any tools to compare db's

From: "Chris Hoover" <revoohc(at)sermonaudio(dot)com>
To: "Rosser Schwarz" <rosser(dot)schwarz(at)gmail(dot)com>,<pgsql-admin(at)postgresql(dot)org>
Subject: Re: Any tools to compare db's
Date: 2004-12-21 00:02:44
Message-ID: 41C76824.1030904@sermonaudio.com (view raw or flat)
Thread:
Lists: pgsql-admin
That really does not work.  It will tell you line by line differences,
but not what object it is.  Also, it does not help to generate the sql
to sync the db's.

Chris

Rosser Schwarz wrote:

>while you weren't looking, Chris Hoover wrote:
>  
>
>>Does anyone know of any good tools that will compare 2 db's and generate a complete listing of any object differences?  
>>    
>>
>
>Perhaps something like:
>
>$ pg_dump --schema-only db1 > db1.sql
>$ pg_dump --schema-only db2 > db2.sql
>$ diff db1.sql db2.sql
>
>would accomplish what you're after?  It does specifically list GRANTs,
>among other things.
>
>/rls
>
>  
>




In response to

Responses

pgsql-admin by date

Next:From: Rosser SchwarzDate: 2004-12-21 04:46:46
Subject: Re: Any tools to compare db's
Previous:From: Artur PietrukDate: 2004-12-20 22:42:09
Subject: Re: PostgreSQL internals and implementation of transactions

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group