It is impossible to enjoy idling thoroughly unless one has plenty of work to do. There is no fun in doing nothing when you have nothing to do. Wasting time is merely an occupation then, and a most exhausting one. Idleness, like kisses, to be sweet must be stolen. - Jerome K. Jerome

The recurring problem with database development is that at some pointyou’ll need to upgrade an existing database and preserve its content.In development environments it’s often possible (even desirable) toblow away the database and rebuild from scratch as often as the codeis rebuilt but this approach cannot be taken forward into morecontrolled environments such as QA, UAT and Production.How?

Drawing from our experiences, we’ve found that one of the easiest waysto allow people to change the database is by using version-controlledSQL delta scripts. We’ve also found it beneficial to ensure that thescripts used to build development environments are the exact same usedin QA, UAT and production. Maintaining and making use of these deltas canquickly become a significant overhead - dbdeploy aims to address this.