pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedcomparison schema/data
6+ messages / 5 participants
[nested] [flat]
* comparison schema/data
@ 2013-07-17 15:00 Javier Urbano Contreras <javier.urbano.contreras@gmail.com>
0 siblings, 3 replies; 6+ messages in thread
From: Javier Urbano Contreras @ 2013-07-17 15:00 UTC (permalink / raw)
To: pgsql-admin
Does anyone any tool in command line for comparison schema/data?
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: comparison schema/data
@ 2013-07-17 20:08 Ketana Patel <contactketana@yahoo.co.in>
parent: Javier Urbano Contreras <javier.urbano.contreras@gmail.com>
2 siblings, 0 replies; 6+ messages in thread
From: Ketana Patel @ 2013-07-17 20:08 UTC (permalink / raw)
To: Javier Urbano Contreras <javier.urbano.contreras@gmail.com>; +Cc: pgsql-admin
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?
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: comparison schema/data
@ 2013-07-18 11:00 raghu ram <raghuchennuru@gmail.com>
parent: Javier Urbano Contreras <javier.urbano.contreras@gmail.com>
2 siblings, 1 reply; 6+ messages in thread
From: raghu ram @ 2013-07-18 11:00 UTC (permalink / raw)
To: Javier Urbano Contreras <javier.urbano.contreras@gmail.com>; +Cc: pgsql-admin
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.
http://www.apgdiff.com/
Thanks & Regards
Raghu Ram
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: comparison schema/data
@ 2013-07-18 11:05 javmendez1@gmail.com
parent: raghu ram <raghuchennuru@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: javmendez1@gmail.com @ 2013-07-18 11:05 UTC (permalink / raw)
To: raghu ram <raghuchennuru@gmail.com>; pgsql-admin-owner@postgresql.org, "Javier Urbano Contreras" <javier.urbano.contreras@gmail.com>; +Cc: pgsql-admin
EMS for PostgreSQL, but it's a graphical tool.
Este mensaje ha sido enviado gracias al servicio BlackBerry de Movilnet
-----Original Message-----
From: raghu ram <raghuchennuru@gmail.com>
Sender: pgsql-admin-owner@postgresql.orgDate: Thu, 18 Jul 2013 16:30:01
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.
http://www.apgdiff.com/
Thanks & Regards
Raghu Ram
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: comparison schema/data
@ 2013-07-18 11:13 raghu ram <raghuchennuru@gmail.com>
parent: javmendez1@gmail.com
0 siblings, 0 replies; 6+ messages in thread
From: raghu ram @ 2013-07-18 11:13 UTC (permalink / raw)
To: javmendez1@gmail.com; +Cc: pgsql-admin-owner@postgresql.org, Javier Urbano Contreras <javier.urbano.contreras@gmail.com>; pgsql-admin
>
>
> 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.
http://www.devart.com/dbforge/postgresql/datacompare/
Thanks & Regards
Raghu Ram
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: comparison schema/data
@ 2013-07-18 16:19 Gezeala M. Bacuño II <gezeala@gmail.com>
parent: Javier Urbano Contreras <javier.urbano.contreras@gmail.com>
2 siblings, 0 replies; 6+ messages in thread
From: Gezeala M. Bacuño II @ 2013-07-18 16:19 UTC (permalink / raw)
To: Javier Urbano Contreras <javier.urbano.contreras@gmail.com>; +Cc: pgsql-admin
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.
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2013-07-18 16:19 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2013-07-17 15:00 comparison schema/data Javier Urbano Contreras <javier.urbano.contreras@gmail.com>
2013-07-17 20:08 ` Ketana Patel <contactketana@yahoo.co.in>
2013-07-18 11:00 ` raghu ram <raghuchennuru@gmail.com>
2013-07-18 11:05 ` javmendez1@gmail.com
2013-07-18 11:13 ` raghu ram <raghuchennuru@gmail.com>
2013-07-18 16:19 ` Gezeala M. Bacuño II <gezeala@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox