It is time to upgrade the production database.
Date: 1996/10/23
Message-ID: <326E77DA.6F9B_at_realsoftware.be>#1/1
Hi fellow Oracle users,
Consider you want to deploy an Oracle database on HP-UNIX and you want to automate the upgrade of the production databases; this must cover an upgrade of both the model and the data.
The model is managed using the tool ERWin of LogicWorks. Note that this is an excellent tool to manage a model. We have built a database methodology around it to manage the database changes.
It is essential that the existing production database is upgraded in-place. The storage capacity of the production machines is most of the time too small to hold the data twice.
I prefer to do a difference analysis between the production version and
the new version.
Who can recommend a tool which can handle this ? A tool from Platinum or
the makers of DBVision is preferred since we already use some software
of these vendors.
The ERWin V2.5 cannot handle such kind of analysis so we need to find another solution for it.
For now, we have built a database difference analysis tool which
a) generates a DDL script to upgrade the production model where
possible.
b) generates a package with a framework to handle the differences that
must be handled by code (plsql). The data conversion must be coded in
thse blocks. An example is a new column which is mandatory. The tool
generates a pl/sql block to add the new column as NULL. Next the
population of the column must be coded, this is businesss driven. As
last, the constraint NOT NULL is added to the column.
Notes :
- the difference analysis focusses on the table, referential integrity
and user-defined indexes.
- the triggers are managed separately; the existing ones are dropped and
the new set is created with a separate script.
- the Sequence objects are not handled yet.
I would like to launch a thread about this subject because it is essential to provide a cost-effective way to upgrade production databases. I prefer a tool which can handle all object types so that the in-house effort is limited for future releases.
Much appreciated,
Rolf Huijbrechts
REAL SOFTWARE
All opinions expressed are mine and not those of my employer.
email : huybrecr_at_realsoftware.be or 101505.533_at_compuserve.com website: http://www.realsoftware.be/
Received on Wed Oct 23 1996 - 00:00:00 CEST