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

Re: Comparing databases

From: Brendan Duddridge <brendan(at)clickspace(dot)com>
To: "Sugrue, Sean" <Sean(dot)Sugrue(at)analog(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Comparing databases
Date: 2006-01-12 04:50:07
Message-ID: 0B455CCB-7F15-4BCF-B21F-DBFD99C7DDBD@clickspace.com (view raw or flat)
Thread:
Lists: pgsql-novice
Navicat has built-in support for schema synchronization. It's pretty  
good.

____________________________________________________________________
Brendan Duddridge | CTO | 403-277-5591 x24 |  brendan(at)clickspace(dot)com

ClickSpace Interactive Inc.
Suite L100, 239 - 10th Ave. SE
Calgary, AB  T2G 0V9

http://www.clickspace.com

On Jan 11, 2006, at 1:34 PM, Tom Lane wrote:

> "Sugrue, Sean" <Sean(dot)Sugrue(at)analog(dot)com> writes:
>> Does anyone know how to structurally compare a list of tables
>> between two different databases without going
>> through them one by one?
>
> You might try "pg_dump -s" on both databases and diff the output.
> Not a perfect tool but it will serve for minor differences.
>
> 			regards, tom lane
>
> ---------------------------(end of  
> broadcast)---------------------------
> TIP 6: explain analyze is your friend
>

In response to

Responses

  • Forums at 2006-01-12 13:38:43 from Mark Campbell

pgsql-novice by date

Next:From: tmorelliDate: 2006-01-12 12:27:58
Subject: A question about pages. Still not clear
Previous:From: Michael FuhrDate: 2006-01-12 04:48:30
Subject: Re: Removing duplicate entries

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