Re: schema diffing tool?

On Jan 11, 2008, at 7:39 AM, Mark Wong wrote:

> On Thu, 10 Jan 2008 15:40:58 -0800
> Jeff Davis <pgsql(at)j-davis(dot)com> wrote:
>
>> On Thu, 2008-01-10 at 15:21 -0800, Selena Deckelmann wrote:
>>> Anyone had a need for or used a schema diffing tool? (for
>>> postgresql,
>>> but if for some other DB might be interested)
>>>
>>> Example: comparing two databases (dev & production) and then
>>> having a
>>> look at the results. Extra credit for pretty output (like ALTER
>>> statements? oh that would be sweet).
>>>
>>
>> I would like such a tool.
>
> Is PostgreSQL Autodoc (http://www.rbt.ca/autodoc/ worth any
> points? It
> won't do a diff, but at least you can visualize it.

Interesting! Thanks.

I was thinking more about something that would provide context, and
whose output could be directly applied to a database.

It's a useful tool, even if you do maintain good revision control.

Hrm... after I finish my backlog for ptop, I will hack something up
in Perl.

-selena

--
Selena Deckelmann
Information Systems Manager
Chris King Precision Components
Made in Portland, Oregon
www.chrisking.com / 503.972.4050 x230