Chapter 12. Legacy Databases

No process can be whole until it has a way to enlist artifacts created before its discovery. In the application world—where designs are relatively easy to change or dispose of—this is true. In the database world—where knowledge adds weight to deployed designs—it goes double.

Legacy databases are typically enormous wads of unspecified behavior. The way they are built and upgraded tends to not conform to the standards set by this book. Before you can think about maintaining any legacy database, you have to coerce it into a class of databases so that you can later write tests.

Rarely does such a design have strong encapsulation and only expose the behaviors that are actually needed. You’ll want to work toward good encapsulation ...

Get Test-Driven Database Development: Unlocking Agility 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.