Creating a Database Continuous Integration Workflow with Datical and AWS

Why create a database continuous integration workflow?

Enterprises are now realizing the need to make database code deployment as fast and easy as application release automation.

Creating a continuous integration database has a lot of benefits, including:

• Discover mistakes more quickly
• Deliver updates faster and more frequently
• Help developers write better code
• Automate the database release management process

The end goal is to make sure database code can be promoted automatically with application code changes. With database continuous integration and delivery, application development teams can deliver smaller, less risky deployments, making it possible to respond more quickly to business or customer needs.

How to create a database continuous integration workflow with Datical and AWS

In a post on the AWS blog, Building End-to-End Continuous Delivery and Deployment Pipelines in AWS, the AWS team walked through steps for implementing a continuous deployment and automated delivery pipeline for your application.

In a follow-up post, Datical joined AWS to walk through steps for building a continuous deployment workflow for databases using AWS CodePipeline (a fully managed continuous delivery service) and Datical (a database release automation solution). We used AWS CodeCommit for source code control and Amazon RDS for database hosting to demonstrate end-to-end database change management — from check-in to final deployment.

As part of that example, we demonstrate how a database change that doesn’t meet standards is automatically rejected and how actionable feedback is provided to the developer. Just like a code unit test, Datical evaluates changes and enforces your organization’s standards. In the sample use case, database table indexes with more than three columns are not allowed. In some cases, this type of index can slow performance.

Check out this AWS example post to learn how to build a modern database continuous integration and automated release management workflow on AWS. You’ll see how Datical seamlessly integrates with AWS services to enable database release automation while eliminating risks that cause application downtime and data security vulnerabilities.

This fully automated delivery mechanism for databases can accelerate every organization’s ability to deploy software rapidly and reliably while improving productivity, performance, compliance, and auditability, while increasing data security. This approach makes it possible for organizations to serve their customers efficiently and compete more effectively in the market.

To learn more about database continuous integration and continuous delivery check out How to Create the Continuous Delivery Database.