differences between schemas
From: Edward Rusu <erusu_at_softcomputer.com>
Date: 2000/06/16
Message-ID: <394a2238_at_smtp2.softcomputer.com>#1/1
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