Software development

Oracle database: schema versioning

When working on a project where the data model isn’t completely stable, you want to be able to run scripts changing one or more database schemas. But how do you make sure that all updates run successfully. And how do you avoid running the same update script twice one a schema.

One a project some years back I had the opportunity to work out a way to handle this.