Recipe 13Automating Database Change Script Creation

Problem: Why should developers have to worry about what changed?

Instead of writing change scripts manually, you want to automate their creation. After all, with database creation scripts under version control, writing change scripts should just be a matter of finding what changed between two revisions in the source control.

Solution

A database isn't one-dimensional like application code because it contains structural information and data. So when you change a database, you have to provide a migration path for the existing data. Creating automated database change scripts is complicated, and a complete solution isn't easily available. For example, the FundPrice table must be changed so that you ...

Get Recipes for Continuous Database Integration: Evolutionary Database Development now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.