Recipes for Continuous Database Integration: Evolutionary Database Development

Introduction

One of the challenges in developing and delivering applications is knowing what changed between builds in development, or in production environments and other environments. Determining changes is easy for application code because the source control, also known as version control, revision control, or Software Configuration Management (SCM), gives you a list of files that changed between two labels or tags in the source control repository. When you want to know what changes were made to the database during development, however, there's no easy way to find out. Even if you determine what changes were made, migrating the database from the old version to the new version is difficult. The database, unlike the code, incorporates the database ...