| From: | Denish Patel <denish(at)omniti(dot)com> |
|---|---|
| To: | "Ferrell, Denise CTR NSWCDD, Z11" <denise(dot)ferrell(dot)ctr(at)navy(dot)mil> |
| Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Comparing two databases for differences |
| Date: | 2014-12-10 14:13:59 |
| Message-ID: | CAFddxvOo+mp2aV70bTkb4D5xcbmkE8NSbZxvkQSY7VigCTKF9Q@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
The easiest way to compare schema by using
https://github.com/omniti-labs/pg_extractor to dump objects into separate
git repo for each database and look for difference in both repos.
On Wed, Dec 10, 2014 at 9:08 AM, Ferrell, Denise CTR NSWCDD, Z11 <
denise(dot)ferrell(dot)ctr(at)navy(dot)mil> wrote:
> Running PostgreSQL 9.3.5 on Linux.
>
> Does anyone know of an easy way to compare 2 database instances?
> Especially the stored procedures and tables from the two databases.
>
> Thank you in advance.
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
--
Denish Patel,
OmniTI Computer Consulting Inc.
Database Architect,
http://omniti.com/does/data-management
http://www.pateldenish.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephen Frost | 2014-12-10 14:14:31 | Re: Comparing two databases for differences |
| Previous Message | Ferrell, Denise CTR NSWCDD, Z11 | 2014-12-10 14:08:12 | Comparing two databases for differences |