␡
- Database Refactoring
- Evolutionary Data Modeling
- Database Regression Testing
- Configuration Management of Database Artifacts
- Developer Sandboxes
- Impediments to Evolutionary Database Development Techniques
- What You Have Learned
This chapter is from the book
1.4 Configuration Management of Database Artifacts
Sometimes a change to your system proves to be a bad idea and you need to roll back that change to the previous state. For example, renaming the Customer.FName column to Customer.FirstName might break 50 external programs, and the cost to update those programs may prove to be too great for now. To enable database refactoring, you need to put the following items under configuration management control:
- Data definition language (DDL) scripts to create the database schema
- Data load/extract/migration scripts
- Data model files
- Object/relational mapping meta data
- Reference data
- Stored procedure and trigger definitions
- View definitions
- Referential integrity constraints
- Other database objects like sequences, indexes, and so on
- Test data
- Test data generation scripts
- Test scripts