Managing Enterprise Database Changes

And hope it isnt that guy who always executes scripts as the wrong user...

Introduction

Managing sql scripts for a small database is simple enough, but what about when you have a large enterprise scale database? How do you manage and apply sql scripts for a database that is built up over many years, developed in parallel by many developers, and made up of hundreds of tables, views and store procedures? Database Migration frameworks such as Liquibase and Flyway have arisen in the past few years as an attempt to solve this problem.
Continue reading