Thread: compare two schemas

compare two schemas

From
AI Rumman
Date:
I have to compare two schamas in two different Postgresql databases to identify the mismatch between the production and development environment databases.
 
Is there any good tool?
 
Any suggestion please.

Re: compare two schemas

From
Devrim GÜNDÜZ
Date:
On Sun, 2010-03-07 at 16:40 +0600, AI Rumman wrote:
> I have to compare two schamas in two different Postgresql databases to
> identify the mismatch between the production and development
> environment
> databases.
>
> Is there any good tool?

http://bucardo.org/wiki/Check_postgres

check_postgres does this. See same_schema option.
--
Devrim GÜNDÜZ
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz

Attachment