Looking for suggestions (A Script, third party tool, software etc.) which can help automate some of the administration tasks around execution of DDL scripts across environments. Database is usually Oracle and MySql
Problem statement: Adding a new column via ALTER TABLE to an existing table. Current process is to send the script to pool of DBAs who get hundreds of such requests from various venues daily. Have to wait for them to pick up the request and then respond which usually takes a day or two. They have to manage that script going forward and execute it in Dev, QA(multiple QA environments) & ultimately PROD. In this process the script is usually lost after PROD and cannot be traced back as to who and why they created a change.
Looking for: Suggestions on how this can be automated. Are there any standard tools or software which can manage scripts across environments. Database is Oracle and MySql.