Re: Schema comparison tool - Mailing list pgsql-general

From Rich Shepard
Subject Re: Schema comparison tool
Date
Msg-id Pine.LNX.4.61.0502161451550.10605@salmo.appl-ecosys.com
Whole thread Raw
In response to Re: Schema comparison tool  ("Ian Harding" <iharding@tpchd.org>)
Responses Re: Schema comparison tool
List pgsql-general
On Wed, 16 Feb 2005, Ian Harding wrote:

> I keep scripts for drop/creation or replacement of each type of object,

>>>> Jeff Amiel <jamiel@istreamimaging.com> 02/15/05 7:01 AM >>>
> I'm looking specifically for a tool to help compare 2 database schemas
> (nominally, production and development) and generate the appropriate SQL

> (that can be later executed) to bring the to schema's into sync.

Jeff,

   Check out subversion, the replacement for cvs. You can keep your schemas
in the repository, modify and compare, merge changes to the head and all
sorts of fun things. Subversion is also for documents.

   Here're the docs: <http://svnbook.red-bean.com/> and here are the sources:
<http://subversion.tigris.org/>.

Have fun,

Rich

--
Dr. Richard B. Shepard, President
Applied Ecosystem Services, Inc. (TM)
<http://www.appl-ecosys.com>   Voice: 503-667-4517   Fax: 503-667-8863

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: hung postmaster?
Next
From: Ron Mayer
Date:
Subject: Re: PostgreSQL vs. MySQL vs. Oracle, 2005 report card