Re: differences between schemas
Date: 2000/06/16
Message-ID: <f2jkkssfuvm8j2f1h215hlp9rib69r4ha5_at_4ax.com>#1/1
ERWin is one such tool. The company used to named Logicworks. I think that Oracle has also has a tool (Designer?) that will compare two schemas.
Jonathan
jonathan_at_gennick.com
http://gennick.com
Brighten the Corner Where You Are
On Fri, 16 Jun 2000 08:49:38 -0400, "Edward Rusu" <erusu_at_softcomputer.com> wrote:
> Hi omniscient All!
> Does anyone know a tool, which can show differences of objects between 2
>schemas? It is desirable, that this tool will be able to
>synchronize definition of objects between schemas.
>
>Here is example.
> Schema S1 has table A(c1 char(10)).
>Other schema S2 has table A(c1 char(20), c2 number).
>I would like to upgrade S1 with objects from S2, so the tool
>should generate a script like:
>alter table S1.A modify (c1 char(20));
>alter table S1.A add c2 number;
>
>Thank you in advance,
>Edward
>
>
Received on Fri Jun 16 2000 - 00:00:00 CEST