DLM Dashboard tracks changes to your database schemas across different environments. In this blog post, we’ll talk about organizing your databases into pipelines, and how this can help you to better understand your workflow.
How was it organized before?
Grouping databases by category
In the first version of DLM Dashboard, databases were grouped by category – or environment – to distinguish stages in the workflow from development to production. For example:
Grouping databases by server
In the next version, you could group databases by their parent server. Many users had a different server for each environment, so it made sense to keep their production servers separate:
What could we improve?
Grouping by category or server worked fine for users who were only tracking one or two database schemas. But what about users monitoring more than one application? When they added more databases, DLM Dashboard grouped database schemas from different applications together. The workflow wasn’t clear, and it wasn’t easy to see which changes were moving from development to production. We knew we could do better.
Grouping databases by pipeline
We started developing a new version of DLM Dashboard that would group databases into pipelines according to their schemas. By grouping databases that share similar schemas, it’s easy to track schema changes as they progress through the stages of your database’s lifecycle.
How does it work under the hood?
DLM Dashboard compares the schemas being monitored and groups those with similar database structures into pipelines. This calculation is based on a distance measurement between the two databases: the more differences there are between two database schemas, the further the distance between them.
For example, look at the FinanceDev and FinanceProd databases below. They use Database/Table/Column to define the objects present in the database schema.
The databases aren’t equal but they’re similar, so they’re grouped into a single pipeline named Finance. The distance between them is small.
Say that we then start to monitor another database, EmployeesProd:
EmployeesProd is placed in its own pipeline (called EmployeesProd) because it’s not similar enough to be grouped with FinanceDev or FinanceProd.
What do users think of pipelines?
We added in-app feedback along with this new feature, to find out how accurately DLM Dashboard groups different users’ databases.
The questionnaire has been live for five weeks and, with over 600 responses, the results have been largely positive:
The team are now exploring ways to make pipelines even better. We’ve already added the ability to apply a filter to the databases in a pipeline, so you can define what drift means to you, and ignore changes you’re not interested in. We’re currently working on support for manually configured pipelines, so you can control exactly how your database schemas are grouped.
Comments or questions? We’d love to hear from you. Please send your feedback to firstname.lastname@example.org
Also in Blog
In this three-part series, guest bloggers from DevOpsGuys look at the real role of Ops in DevOps. Where it changes, how it changes, and why Ops has an important part to play in the brave new world of ...
Also in DLM Dashboard
As a DevOps engineer at Redgate, I’m one of those responsible for keeping the systems going behind the scenes. That’s everything from the internal systems and databases to the infrastructure that ...
Also in Hub
My previous article in this series explained why it's important for a development team to adopt a common standard for formatting SQL code. It also gave a broad overview of the styles and actions withi...
Also in Product learning
With ten programmers working on the same project, how do you agree on a standard style for formatting SQL code, and then implement it consistently? One way is through draconian rules, meeting after me...
Also in Redgate products
Today, we launched SQL Clone v2, which removes the previous 2TB size limit and now supports cloning databases up to 64TB. In this article, I'll explain why I think this is big news for many organizati...
Also about DLM Dashboard
For a time in the late 1800s in America, the offer of a FREE LUNCH! was a way to entice people into a bar. Get some free food, you only have to buy one drink. In short, the food wasn’t free, and ...