Re: Reporting on differences between 2 schemas

PowerDesigner (Sybase) actually has an option to compare two schemas. But you can also do it yourself, e.g. to find differences between tables:

select a.table_name, a.column_name, a.data_type, a.data_length, a.data_precision,
 a.data_scale, a.nullable
from all_tab_columns a
where owner = 'X'
minus
select b.table_name, b.column_name, b.data_type, b.data_length, b.data_precision,
 b.data_scale, b.nullable
from all_tab_columns
where owner = 'Y'

--
Terry Dykstra (TeamPS)
Canadian Forest Oil Ltd.
Jim Baker wrote in message <36507465.6777BA1B_at_altavista.net>...
>Folks,
>
>I have recently inherited a development schema with a slightly checkered
>history - its design was originally held in a tool called PowerDesigner
>(not one I know) but has since been reverse engineered into Designer
>v2.1, comments being loaded by an (undocumented) set of scripts calling
>the Designer API.
>
>I want to produce a version control report describing the differences
>between two versions of the schema, both of which are held on the
>database and in the D2K repository. It would be nice to get a flat text
>report of some kind, suitable for automatic processing, but anything
>would be useful. If you have scripts which try and establish
>differences between two schemas, they'd be useful to me, as would custom
>reports for Designer which give a breakdown of changes to the server
>model at the column level between sucessive versions of an application
>system. I will also have to document changes to constraints.
>
>The platform is AIX server, NT client. Dodgy shell/sqlplus scripts
>would be gratefully accepted - I just don't really fancy writing scripts
>from scratch.
>
>If you've got anything which you think might be useful, please post or
>email me at JimBaker_at_altavista.net if you've got large scripts/binaries.
>
Received on Mon Nov 16 1998 - 14:03:56 CST