Re: comparing database schema's

From: Francisco J Reyes <fran(at)natserv(dot)net>
To: John Harrold <jmh17(at)pitt(dot)edu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: comparing database schema's
Date: 2003-07-28 20:59:07
Message-ID: 20030728165521.A71107@zoraida.natserv.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, 22 Jul 2003, John Harrold wrote:

> can anyone offer a way to compare db schema?

If you have access to a windows machine you could check PostgreSQL
Database Comparer at
http://www.ems-hitech.com/pgsqlutils/

I just started to test it a couple of days ago, but it does seem to show
differences.

If you do try it, be watchfull of the direction of the changes. I think
there is a bug and the changes are not done in the right direction (ie you
tell it to make database A the same as B, but instead it gives you the
code on how to make B the same as A).

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2003-07-28 21:00:59 Re: CREATE TABLE with REFERENCE
Previous Message Jonathan Bartlett 2003-07-28 20:55:26 Re: CREATE TABLE with REFERENCE