From: | "Vincent Hikida" <vhikida(at)inreach(dot)com> |
---|---|
To: | "John Harrold" <jmh17(at)pitt(dot)edu>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: comparing database schema's |
Date: | 2003-07-22 19:54:08 |
Message-ID: | 02b201c3508b$03c56450$210110ac@HOMEOFFICE |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I wrote a utility once at a company where I worked previously that did this.
It did compared the meta data tables of the the two schemas. This was in
Oracle though. I think it took me less than a week to do. It might be a nice
utility to build for postgres.
It started with code as
SELECT TABLE_NAME
FROM USER_TABLES
MINUS
SELECT TABLE_NAME
FROM USER_TABLES(at)XYZ
/
And vice versa.
It then compared columns of common tables, the characteristics of the
columns, the indexes etc and used PL/SQL.
Vincent Hikida,
Member of Technical Staff - Urbana Software, Inc.
"A Personalized Learning Experience"
----- Original Message -----
From: "John Harrold" <jmh17(at)pitt(dot)edu>
To: <pgsql-general(at)postgresql(dot)org>
Sent: Tuesday, July 22, 2003 11:46 AM
Subject: [GENERAL] comparing database schema's
From | Date | Subject | |
---|---|---|---|
Next Message | scott.marlowe | 2003-07-22 20:46:09 | pronouncing postgresql |
Previous Message | Tom Lane | 2003-07-22 19:35:27 | Re: [GENERAL] INSTEAD rule bug? |