This book describes how to apply the business and technical approaches of Database Lifecycle Management (DLM) and DevOps, to make database change management processes more visible, predictable, and measurable. It explains, strategically, the tools, skills, and methods that will allow an organization to:
- Plan for effective database and data governance through all phases of DLM
- Achieve automated and consistent database builds from version control
- Avoid data loss when modifying existing databases by using database migrations
- Integrate and test code with a continuous integration process
- Deploy and release reliable database code more frequently
- Use issue tracking for reporting bugs in the code, anomalies, and incidents from live environments
By making the processes we use to develop, release, deploy, and maintain databases more visible, predictable, and measurable, and working together more effectively as a team, organizations can start to reap the benefits of faster delivery, reduced costs, and increased quality.
Contents
- What is Database Lifecycle Management (DLM)?
- DevOps and Database Lifecycle Management
- Planning for a Successful Database Lifecycle
- Managing data as part of DLM
- Database Version Control
- Better Ways to Build a Database
- Database Migrations: Modifying Existing Databases
- A DLM Approach to Database Testing
- Database Continuous Integration
- Database Deployment and Release
- Issue Tracking for Databases
- Database Lifecycle Management for ETL Systems