Thread: comparison schema/data
Does anyone any tool in command line for comparison schema/data?
DB Solo is a good tool for schema comparison. But it's not a command line tool.
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
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?
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
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
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
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.