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:
Redgate 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.”
The key to the successful introduction of DLM is to see it not as a single, rigid, rulebook process that forces you to change every aspect of the way your organization works.
DLM is a staged process that can be implemented in your own timeframe, depending on what’s right for your organization. You can choose where to step into the lifecycle, and where to stop or move forward. Each step offers benefits in its own right.
No source control, or manual, ad hoc source control
Automated source control solution
CI and source control for the database
Source control, CI, and automated deployment
Drift checking and performance monitoring
To enjoy the benefits of more advanced agile practices, moving from no source control to source control is the first step (and the best way of doing this is by using a proper source control tool).
As you move on, you can then choose to implement continuous integration and release management to establish a continuous delivery process.
Redgate’s DLM solution offers tooling to support each process, which can be used individually or together to deliver the whole range of DLM benefits.
Redgate’s DLM products plug into the infrastructure your organization already has in place to cover application lifecycle needs – your source control system, your CI server, and your release management tool.
The SQL Developer Suite includes SQL Source Control, a plugin that lets you use your source control system to version control your database: the first step in managing your database lifecycle.
It also gives you seven tools for development and manual change management – everything you need to get started with DLM.Deployment Suite for Oracle, which includes Source Control for Oracle, a standalone tool which lets you use Subversion or Team Foundation Server with Oracle databases.
The DLM Automation Suite works with your existing CI and release management infrastructure, so you can include your database in both processes. It also provides you with the review and approval steps you need to make sure your process is safe.
With it, you can make automated deployments – and even continuous delivery – a reality for your database.DLM Automation Suite for Oracle, which lets you add your Oracle database to your CI process.
Find out how major UK utility company Yorkshire Water saved an estimated £978,880 (US $1.5 million) by switching to Redgate DLM tools.
Redgate has specialized in database software for 15 years.
Our products are used by 650,000 IT professionals, in more than 100,000 companies, including 91% of the Fortune 100.
Our philosophy is to design highly usable, reliable tools, which elegantly solve the problems that development and operations teams face every day.