DLM Automation Archives - Redgate Software

Posts Tagged with DLM Automation

Database CI with Redgate DLM Automation, PowerShell and Jenkins

While the practice of Continuous Integration (CI) started with application code, you can apply the same principles to databases. Database CI is the process by which we build, test and deploy the database on commit of every database change, and report any errors. In this way, CI reduces your feedback loop such that changes... read more

Database automation made easier

Last week saw the release of DLM Automation – a new improved version of our database automation offering. So what’s changed? DLM Automation combines all the functionality of its predecessors, SQL CI and SQL Release, in one unified tool. This means you now only need to install one product in order to set up... read more

Is your SQL code covered?

No, it almost certainly isn’t. Besides, how would you know either way? Let me explain. Most modern software development today includes some form of automated testing. While comprehensive unit testing is still sorely lacking in many organizations, it’s often mitigated by other forms of automated testing conducted later on in the development cycle. Code... read more

Using database replication with automated deployments

The Redgate DLM Automation team that we’re part of took time out from development to explore some of the issues our customers face when automating database deployment. Following on from previous posts about cross-database and cross-server dependencies and production database drift, this blog shares some of our thoughts about how to deal with database replication. Database replication... read more

We don’t need no documentation – automating schema docs in Redgate DLM

“Understanding the existing product consumes roughly 30 percent of the total maintenance time.” Facts and Fallacies of Software Engineering by Robert L. Glass. You should be documenting your database schemas. I know it, you know it. Having (current, accurate) documentation available accelerates time-to-resolution for faults, aids tech-to-business conversations, and is a regulatory requirement for a great number of... read more

Dealing with production database drift

The Redgate DLM Automation team that we’re part of recently took time out from development to explore some of the issues our customers face when automating database deployment. Following on from last week’s post about cross-database and cross-server dependencies, this blog shares some of our thoughts about how to deal with production database drift.... read more

DLM Automation add-ons

Many software teams are already integrating their application code but haven’t yet brought the continuous integration discipline to their database development. With DLM Automation, you can extend that process by plugging into third party tools commonly used for application development. It’s now even easier to find the add-on you need for your build or release... read more

Sometimes the tool just fits – using Redgate DLM and Octopus Deploy for data change control

From a business risk perspective, data change can be just as significant as code or schema change. Sometimes even more so; an incorrect static (or reference, or master) data change can drive your software’s behaviour more dangerously askew than pretty much any bug can. Imagine treating a retail customer for an investment fund as a corporate... read more