oramerge – Three-way merging of schemas
Purpose
oramerge can be used for merging the changes between two Oracle
database schemas into a third one. Depending on the existance/non-existance
of schema objects in the three schemas oramerge does the right thing.
If a schema objects exists in all three schemas, the external tool
merge3 will be used for creating a merged version of the object
(except for tables where the appropriate ALTER TABLE
statements will be
output if possible).
Options
oramerge supports the following options:
- -v <flag>, --verbose <flag>
Produces output (on stderr) while the database is read or written. (Valid flag values are
false
,no
,0
,true
,yes
or1
)
- -c <mode>, --color <mode>
Should the output (when the
-v
option is used) be colored? Ifauto
is specified (the default) then the output is colored if stderr is a terminal. Valid modes areyes
,no
orauto
.
Example
Output a script that merges the changes between user@db
and user2@db2
into user3@db3
:
$ oramerge user/pwd@db user2/pwd2@db2 user3/pwd3@db3 -v >db.sql