Thread: comparison schema/data

comparison schema/data

From
Javier Urbano Contreras
Date:
Does anyone any tool in command line for comparison schema/data?

Re: comparison schema/data

From
Ketana Patel
Date:
DB Solo is a good tool for schema comparison. But it's not a command line tool.

Regards,
Ketana


From: Javier Urbano Contreras <javier.urbano.contreras@gmail.com>
To: pgsql-admin@postgresql.org
Sent: Wednesday, 17 July 2013 11:00 AM
Subject: [ADMIN] comparison schema/data

Does anyone any tool in command line for comparison schema/data?


Re: comparison schema/data

From
raghu ram
Date:

On Wed, Jul 17, 2013 at 8:30 PM, Javier Urbano Contreras <javier.urbano.contreras@gmail.com> wrote:
Does anyone any tool in command line for comparison schema/data?

Another PostgreSQL Diff Tool (also known as apgdiff) is free PostgreSQL diff tool that is useful for comparison/diffing of database schemas. 


Thanks & Regards
Raghu Ram

Re: comparison schema/data

From
javmendez1@gmail.com
Date:
EMS for PostgreSQL, but it's a graphical tool.
Este mensaje ha sido enviado gracias al servicio BlackBerry de Movilnet

From: raghu ram <raghuchennuru@gmail.com>
Sender: pgsql-admin-owner@postgresql.org
Date: Thu, 18 Jul 2013 16:30:01 +0530
To: Javier Urbano Contreras<javier.urbano.contreras@gmail.com>
Cc: <pgsql-admin@postgresql.org>
Subject: Re: [ADMIN] comparison schema/data


On Wed, Jul 17, 2013 at 8:30 PM, Javier Urbano Contreras <javier.urbano.contreras@gmail.com> wrote:
Does anyone any tool in command line for comparison schema/data?

Another PostgreSQL Diff Tool (also known as apgdiff) is free PostgreSQL diff tool that is useful for comparison/diffing of database schemas. 


Thanks & Regards
Raghu Ram

Re: comparison schema/data

From
raghu ram
Date:

On Wed, Jul 17, 2013 at 8:30 PM, Javier Urbano Contreras <javier.urbano.contreras@gmail.com> wrote:
Does anyone any tool in command line for comparison schema/data?


dbForge Data Compare for PostgreSQL is a tool for table data comparison and synchronization. When using  PostgreSQL data compare tool you can detect data differences in compared PostgreSQL tables. 


Thanks & Regards
Raghu Ram
 

Re: comparison schema/data

From
Gezeala M. Bacuño II
Date:



On Wed, Jul 17, 2013 at 8:00 AM, Javier Urbano Contreras <javier.urbano.contreras@gmail.com> wrote:
Does anyone any tool in command line for comparison schema/data?

You can write a simple script for this. For DATA, pg_dump -a (data only) the tables then use "sort" then "diff". For Schema, that's easier, just do a "diff" on a schema only dump.