Making AI scalable with database change management and Redgate Flyway

With the rise of AI and machine learning comes data. Lots of it. For organizations today, AI is radically changing the way data is accessed, maintained and operationalized. For heads of architecture and development teams, it offers opportunity and responsibility. Opportunity to: Accelerate development team productivity AI can be a collaborative force to speed up Read more

Deploying PostgreSQL DB Changes Through AWS Developer Tools Using Flyway

The fundamentals of deploying database changes through Flyway are pretty simple. At the root of it all, there are two words you need to know: This of course comes with a whole set of assumptions. You’ve set up your configuration to connect to the correct database being just one of them. And that’s talking about Read more

DevOps
Blog

The business value of frequent deployments: Faster time to market

In this series, we’ve been exploring the different layers of business value you can gain from deploying software more frequently. We’ve already looked at the hard costs you can save, and the valuable developer time you can recoup. But that’s not the end of the story. Not by far. Picture an iceberg. The top, the Read more

DevOps

The business value of frequent deployments: Recouped time

The first post in this series introduced the idea of the different layers of value that your business can gain from frequent deployments and focused on the hard costs you can save. We’re looking at the role the database plays here because it’s the most complicated part of the process and it’s difficult to hit Read more

DevOps

The business value of frequent deployments

We’ve written a ton of content about how to unlock the value of frequent deployments for your database as well as applications, from improved coding patterns to strategies for architecting smaller deployments. But the multi-million-dollar question for you and your business is something else entirely: what is the real business value of frequent deployments? That’s Read more

Managing PostgreSQL Extensions Using Flyway

Any reliable DevOps deployment process must not only deliver the right database code but also ensure that the correct conditions exist for the deployment to succeed. For PostgreSQL databases, this includes ensuring that any extensions on which the database code relies are installed, and at the correct version. Fortunately, Flyway will automatically track which extensions are installed on a database and at what version, so we can 'propagate' these changes accurately during deployments and avoid inconsistencies in database behavior and even application breakages. Read more

Moving from application automation to true DevOps by including the database

This article explains the challenges of DevOps automation for databases, starting with how to manage the database, as a set of SQL scripts, in the version control system, and then how to start building an integrated and automated script pipeline for continuously testing and deploying database schema changes, alongside the application code. Read more

Deploying Data and Schema Together with SQL Compare or SQL Change Automation

You want to use SQL Compare or SQL Change Automation (SCA) to create or update a database, and at the same time ensure that its data is as you expect. You want to avoid running any additional PowerShell scripting every time you do it, and you want to keep everything in source control, including the data. You just want to keep everything simple. Phil Factor demonstrates how it's done, by generating MERGE scripts from a stored procedure. Read more

From Source Control to Database using SQL Compare Command Line

Giorgi Abashidze explains how his team use SQL Compare Command line to automate database deployments for their customers, without having access to the real staging or production databases, merely by using our development database contained under TFS Source Control. Read more

SQL Compare 14.0: A Command Line Interface on Linux and support for SQL Server 2019

SQL Compare is the industry standard tool for comparing and deploying database schema changes, and version 14.0 now provides a Command Line Interface (CLI) on Linux (available as a beta, at time of writing). Teams working with SQL Server on Linux, or across multiple platforms, benefit from seamless development processes, driven by SQL Compare, without Read more

Redgate Test Data Manager

Redgate Flyway

Redgate Monitor

Overview

Protect

Automate

Monitor

Product articles