From: | Selena Deckelmann <sdeckelmann(at)chrisking(dot)com> |
---|---|
To: | Mark Wong <markwkm(at)gmail(dot)com> |
Cc: | Jeff Davis <pgsql(at)j-davis(dot)com>, Selena Deckelmann <selenamarie(at)gmail(dot)com>, Postgresql PDX_Users <pdxpug(at)postgresql(dot)org> |
Subject: | Re: schema diffing tool? |
Date: | 2008-01-14 19:32:10 |
Message-ID: | BCA3C4E3-7FD3-49CE-905A-2BA9911CD427@chrisking.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pdxpug |
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
From | Date | Subject | |
---|---|---|---|
Next Message | jason kirtland | 2008-01-14 19:53:39 | Re: schema diffing tool? |
Previous Message | Rich Shepard | 2008-01-11 16:10:51 | Re: schema diffing tool? |