Posts Tagged with DLM Automation

28 July 2016

28 July 2016

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

7 June 2016

7 June 2016

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

30 December 2015

30 December 2015

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

3 December 2015

3 December 2015

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

Deploying cross-database dependencies to different environments

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 deployment of database changes.  As part of that exercise, we took a closer look at cross-database and cross-server dependencies – these can cause problems when deploying databases to... Read more

30 June 2015

30 June 2015

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