Database Change Control Process
From: Jeff C <backseatdba_at_gmail.com>
Date: Tue, 25 Feb 2014 08:25:43 -0800
Message-ID: <CAKsxbLqv48MmvEiuci2oJTUcSNqeV7AoGPmeLN=35Jg56ObyNw_at_mail.gmail.com>
I am curious how everybody handle database change control. I am not talking about just source control for your code but the process of moving changes into the database, like procedure changes, alter tables, indexes, manually update of data, etc. Do you have a formal process to go through and what is that like if you are willing to share. We are a private company so things have been kind of light here and we don't have any credit card data. We source control, plus we have a project/bug tracking program that most but not all code changes are related to, and then all code is reviewed before moving to production. Oh and I have a ddl trigger enable to save all updates. But I don't feel like all of this tells a true story. I think we need something more formal and I am trying to gather ideas and opinions before I move forward with the idea.
Date: Tue, 25 Feb 2014 08:25:43 -0800
Message-ID: <CAKsxbLqv48MmvEiuci2oJTUcSNqeV7AoGPmeLN=35Jg56ObyNw_at_mail.gmail.com>
I am curious how everybody handle database change control. I am not talking about just source control for your code but the process of moving changes into the database, like procedure changes, alter tables, indexes, manually update of data, etc. Do you have a formal process to go through and what is that like if you are willing to share. We are a private company so things have been kind of light here and we don't have any credit card data. We source control, plus we have a project/bug tracking program that most but not all code changes are related to, and then all code is reviewed before moving to production. Oh and I have a ddl trigger enable to save all updates. But I don't feel like all of this tells a true story. I think we need something more formal and I am trying to gather ideas and opinions before I move forward with the idea.
Thanks for any input.
Jeff
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Feb 25 2014 - 17:25:43 CET