| 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
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.
 |
 |