DLM Automation - Code Aperture

Code Aperture

Sign in Subscribe

DLM Automation

A collection of 14 posts

Infrastructure: Setup Octopus Deploy to use Redgate DLM Automation

Automated database deployments is a critical aspect of any continuous integration pipeline. The tooling today has made it very easy to get that added, especially if you use Octopus Deploy and Redgate DLM Automation. It is very easy to add the necessary step templates into Octopus Deploy to get Redgate

Multi-Thread Redgate DLM Deployments

The time had finally come. It was time to run the Redgate automated database deployment process in production for the first time. All we had to do was click the deploy button in Octopus Deploy, and we would be on our way. The button was pressed, and we were on

Increased Database Security: Another Reason to Adopt DevOps

The tooling necessary to incorporate DevOps practices is already out there. There are many different flavors of build tools, Jenkins, TeamCity, VSTS, AppVeyor, and Bamboo. Release management is covered by Octopus Deploy, Release Management, and Bamboo. And finally, database automation tooling provided by Redgate SQL Toolbelt and Microsoft SSDT. The

Redgate SQL Toolbelt over Microsoft SSDT: My Biased Opinion

Back in the article How Redgate Helped Define our Process [https://www.codeaperture.io/2016/09/13/how-redgate-helped-define-our-process/], there was this small blurb about SSDT: > Microsoft SSDT Tooling Considered - the increased cost of licenses forced us to take a hard look at Microsoft's SSDT tooling. Could it do what

Automated Deployments is Mission Critical

In my late twenties, I was hired to work on a project for a new client. The project was to add a lot of new features to a SaaS application. The client was the largest player in its particular industry and wanted a lot of customizations. After several months of

Redgate Command Line Tools

Redgate Command Line Tools

One of the less common known facts about Redgate's DLM Automation suite is purchasing license grants the purchaser the right to use to command line versions [https://documentation.red-gate.com/display/SC12/Integrating+the+command+line+with+applications] of SQL Data Compare and SQL Compare. Seems strange, right? Well when

Static Data with Multiple Database Tenants

The loan origination system my team and I are responsible for have 20 tables marked as static data in Redgate's SQL Source Control. One example of static data is a tile type. The loan origination system has a dashboard made up of multiple tiles. There are six different types of

Using SQL Source Control to Filter Out Unwanted Items

Using SQL Source Control to Filter Out Unwanted Items

Everything written on this site is how to get a database change automatically pushed up through the environments. But that was for the entire database. There are some parts of the database where they shouldn't be put under source control or shouldn't be promoted. Now you are probably thinking, "that

Rollbacks with Automated Database Deployments

Rolling back a database deployment is one the most complicated topics with Automated Database Deployments. The code is rather easy to rollback, just deploy the previous version of the code package and call it good. It is just as easy to rollback database schema changes using Redgate's Database Lifecycle Management

How Redgate Helped Define Our Process

Without the help of Redgate, Farm Credit Services of America's automated database deployment process would not be where it is today. I'm not just talking about their tooling. Their employees have been an invaluable resource. In September 2014 Redgate sent a pair of employees, Alex Yates [https://twitter.com/_AlexYates_

Using Gitflow and Redgate DLM Automation for Continuous Delivery

One of the key reasons to use Redgate's Tooling is to deliver value faster to the business. In order to do that, it is important to have a branching policy in place. This is only possible with a local database and Redgate's tools. Prior to implementing their tools, all developers

Scenarios not supported by Redgate DLM Automation Suite

Redgate has built a fantastic Database Lifecycle Management (DLM) suite to help with automated database deployments. Their tools cover 95% of the scenarios most people will encounter day in and day out. But...it cannot cover 100% of the scenarios. The other 5% of the scenarios are what this post

Visual Studio Team Services Build with Redgate DLM Automation Build

One of the great parts about Microsoft's new Visual Studio Team Services (formerly Visual Studio Online) build [https://www.visualstudio.com/en-us/docs/build/overview] is the extensibility. Anybody can make custom build steps to bring in. Redgate has taken advantage of that extensibility and made a custom step so

Getting Started with Red Gate DLM Automation Suite

Red Gate's DLM Automation Suite is the second half of the automated database deployments process. It takes the scripts that were created by SQL Source Control, builds a package, and then deploys that package to the various database environments (test, staging, production, etc.). Red Gate has built the tooling so