Re: Schema diff tool?

From: "Boyd, Craig" <craig(at)mysoftforge(dot)com>
To: David Kerr <dmk(at)mr-paradox(dot)net>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Schema diff tool?
Date: 2009-08-21 18:59:43
Message-ID: 4A8EEE9F.5040203@mysoftforge.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

We are on 7.3.0.1666.

ODBC alter scripts do tend to be, um, ugly.
When you do the CC are restricting the objects you CC? Try to keep it
as minimal as possible. If I get some time over the weekend I will see
what I can do. No promises though as it is already pretty booked. :)
If I do get the time then I will send you the options xml and the steps
I used to recreate.

Thanks,

Craig Boyd

David Kerr wrote:
> we're on v7.2.8
>
> there's no pg specific option so we've been using ODBC as the
> "database" type and the alter's it generates are just ugly.
>
> Dave
>
> Boyd, Craig wrote:
>> What version of ERwin are you using?
>>
>> Thanks,
>> Craig Boyd
>>
>> David Kerr wrote:
>>> Is there a default/standard (free) schema diff tool that's in use in
>>> the community?
>>>
>>> I'd like to be able to quickly identify new columns, data changes,
>>> new indexes, etc between 2 schema versions.
>>>
>>> (and then create an alter script for the original)
>>>
>>> We're using ERWin as our modeling tool, but it's diff's stink.
>>>
>>>
>>> Thanks
>>>
>>> Dave
>>>
>>
>
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2009-08-21 19:00:02 Re: "Number of columns exceed limit" on a hierarchy of views
Previous Message Alban Hertroys 2009-08-21 18:59:05 Comparing arrays of composite types