More and more companies are recognizing that agile practices such as continuous integration and continuous delivery are as applicable to databases as they are to applications.
Implemented correctly, they reduce risk, improve efficiency, and deliver value to customers sooner.
Quite simply, they enable organizations to proactively manage the processes involved in the application and database lifecycle, including planning, development, release, and maintenance.
Database Lifecycle Management (DLM) refers to the processes that cover the database as part of the wider lifecycle management question.
Just like Application Lifecycle Management (ALM), DLM takes a wide-angle view across the software lifecycle, encouraging teams to use a range of processes and technology infrastructures to manage database changes.
The 2014 State of DevOps report found that:
Red Gate provides DLM products that enable your organization to include databases alongside applications in agile processes, and become a truly high-performing IT organization.
“The journey of managing a team-developed application and its database involves many stages and it is vital a process is put in place to manage all these people, their code, and their environments.”
Red Gate SQL Lighthouse is a free beta tool that tracks ad hoc changes to your database schema. Where a release management tool tells you what you last deployed, SQL Lighthouse shows you if that’s still what’s running on your server.
If there are unexpected changes, SQL Lighthouse provides an audit history of who changed what, and when they did it.
Your Operations team can use it to see what schema state is deployed on any of your database environments, and as a final safety check before deploying to Production.
If you have any questions about DLM and where Red Gate’s tools can help you, please contact us to arrange a consultation.
Email us at email@example.com