differences between schemas

From: Edward Rusu <erusu_at_softcomputer.com>
Date: 2000/06/16
Message-ID: <394a2238_at_smtp2.softcomputer.com>#1/1


        Hi omniscient All!
[Quoted]     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

Original text of this message