I have an Oracle based ColdFusion application. I am looking for an Oracle scripting guru to write a script that will package up and deploy multiple objects - table definitions, indexes, sequences, stored procedures etc in order to simplify the deployment of a system update to a client.
I need to leave the existing data in place and "upgrade" the system around it - in the past I have used individual SQL scripts to make a change to a table or to update a stored procedure - but I want to package mutliple changes in the one update without manually running numerous scripts.
Happy to accept advice if scripting is not the way to go this.