Knowing more today than yesterday is good news about today, not bad news about yesterday.
This chapter describes some of our experiences with database refactoring on actual projects, and suggests a few potential strategies that you may want to consider. In many ways, this chapter summarizes a collection of “lessons learned” that we hope will help your adoption efforts. These lessons include the following:
• Smaller changes are easier to apply.
• Uniquely identify individual refactorings.
• Implement a large change by many small ones.
• Have a database configuration table.
• Prefer triggers over views or batch synchronization.
• Choose a sufficient deprecation period.
• Simplify your ...