| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: looking for a good way to change manage oracle
Well,
To compliment what Tom mentions about the formal Change Request effort. How
about a data model driven approach as well? There are a few tools that will
"merge the data models" based on the concurrency that you mention and gen
SQL/DDL/DML based on a "project basis". Thus, you can also ensure that the
logical/physical aspect of the schemas stay aligned with a Formal SDLC for
the Database changes that Tom has mentioned.
This may seem like a "little over the top". But it saved my teams' "hide" a few times in previous jobs..
greg
-----Original Message-----
From: Mercadante, Thomas F [mailto:thomas.mercadante_at_labor.state.ny.us]
Sent: Friday, December 10, 2004 8:05 AM
To: 'ryan_gaffuri_at_comcast.net'; oracle-l_at_freelists.org
Subject: RE: looking for a good way to change manage oracle
Ryan,
It seems that your approach is always playing catch-up. Here, we developed a very simple Database Request system. Developers cannot make any changes anyplace - they have to request a change be made via the request system. The application tracks all changes and what level of the database they have been applied to (Dev, Staging or Production). Simple reports can be generated showing what changes are in Dev, but not in staging yet.
I'm really talking about managing your change requests a little better. If you manage your requests better, then you don't need a schema compare functionality.
Hope this helps.
Tom
-----Original Message-----
From: ryan_gaffuri_at_comcast.net [mailto:ryan_gaffuri_at_comcast.net]
Sent: Thursday, December 09, 2004 5:01 PM
To: oracle-l_at_freelists.org
Subject: looking for a good way to change manage oracle
We have 13 development databases, 8 parallel development tracks, and 2
concurrent sustainment releases all developing at the same time. We are
having alot of trouble with change management. I am looking for an easy way
to do the following:
take a snapshot of the metadata of a database at a point in time.
compare it at a later point in time or to another database and see the
differences.
What we have tried
1. Designer and change manager(OEM) are really slow. 2. Toad does not appear to be complete 3. Writing code with dbms_metadata is a major task. 4. export won't work, because the order of the objects in the file could bedifferent in different databases, do to different releases applied at different times.
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Dec 10 2004 - 07:21:50 CST
 |
 |