In my experience of database deployments there are a number of challenges :

Critical data is changed incrementally – meaning you’re normally making changes to critical data , as opposed to rebuilding the data from nothing.

Order of changes – it is imperative the scripts are in order. CREATE TABLE , add data

One execution – data changes – only make once

Rollback – safeguard against data integrity corruption

I’ve started reviewing IBM Urban Code Deployment , with a view to utilising in Database changes. It’s to support a very agile environment .

What’s your experience?

Skills required for rapid development

The Agile DBA