Re: Managing schema and database changes

Hi Matt,

This is (has to be) a joint effort between the app and dba teams. I have used Kintana (previously Apps*Link, now Mercury (HP) ITG) as a tool that can perform and manage the migration workflow very well. Let me know if you need more info. ITG can do all the gatekeeping, controls, etc but be aware there is a cost to procure, install, setup and maintain, and it aint cheap

John

On 8/28/08, Nigel Thomas <nigel.cl.thomas_at_googlemail.com> wrote:
> Matthew
>
> This has come up several times before on this list. I blogged on
> it,<http://preferisco.blogspot.com/2008/02/schema-version-control.html>referencing
> one such thread, and some other postings, last Feb:
>
> *An outbreak of synchronicity has produced a volley of blogs and questions
> about database version control in the last few days.*
>
> - *Tom Kyte adds <http://tkyte.blogspot.com/2008/02/hear-hear.html> his
> own twist to this story at Coding
> Horror<http://www.codinghorror.com/blog/archives/001050.html%20version%20control>
> .*
> - *JAson Hinds asked about database release management
>
> <http://forums.oracle.com/forums/thread.jspa?messageID=2315208&#2315208>on
> one of the OTN forums.*
> - *And Syed Jaffar Hussein (the Human
> Fly)<http://jaffardba.blogspot.com/>launched a
> thread on
> Oracle-L<http://www.freelists.org/archives/oracle-l/01-2008/msg00826.html>on
> the subject.
> *
>
>
> Hope that helps for starters...
>
> Regards Nigel
>

-- 
Sent from Gmail for mobile | mobile.google.com

John Kanagaraj <><
http://www.linkedin.com/in/johnkanagaraj
http://jkanagaraj.wordpress.com (Sorry - not an Oracle blog!)
** The opinions and facts contained in this message are entirely mine
and do not reflect those of my employer or customers **
--
http://www.freelists.org/webpage/oracle-l