| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | tmorelli | 2006-01-12 12:27:58 | A question about pages. Still not clear |
| Previous Message | Michael Fuhr | 2006-01-12 04:48:30 | Re: Removing duplicate entries |