Discover the real state of Database DevOps in Financial Services in Redgate’s latest report

Earlier this year we published the 2020 State of Database DevOps report, in which the responses from thousands of IT professionals gave us a unique insight into how organizations and individuals are adopting DevOps. It also covers how teams operate, key areas for optimization, and the biggest challenges they currently face. To gain a... Read more

Organising your Migrations

In Flyway 6.4.0 we introduced a new feature, support for wildcards in the locations. With this feature a new set of solutions to organizing your migration files has now become available. In this post we hope to detail some of them, to aid the users of Flyway in deciding the solution that best suits their environment.... Read more

Pitfalls with SQL rollbacks and automated database deployments

While it’s possible to perform SQL rollbacks to revert database changes, the question is, should you? Rolling back a database change isn’t as straightforward as rolling back a code change. Databases are the lifeblood of applications. An unsuccessful rollback can result in bad or deleted data. This article goes through the pitfalls which result... Read more

Octopus Deploy

6 April 2020

Octopus Deploy

6 April 2020

Designing an automated database deployment process: case study

In my previous article, How to design an automated database deployment process, I wrote about the steps companies and organizations should take to introduce automation to their database deployments. In this article, I’m going talk about the challenges I faced when I embarked on my own automation journey. Prior to joining Octopus Deploy, I... Read more

Andrea Giardina

24 March 2020

Andrea Giardina

24 March 2020

How PASS won the DBTA Database DevOps Innovation Award for fully automating their database deployments

On March 2, DBTA announced PASS as the winner of its inaugural Database DevOps Innovation Award. Redgate is extremely pleased with the news because we’ve really enjoyed working with PASS, and their team really deserves this recognition for what they’ve achieved since 2018. The journey at PASS to a streamlined database change process provides... Read more

Philip Liddell

19 March 2020

Philip Liddell

19 March 2020

Timestamps and Repeatable Migrations

In Flyway 6.3.0 we introduced a new feature. The ability to use the ${flyway:timestamp} placeholder (See Placeholders for more details). This placeholder will insert the current date in the format yyyy-MM-dd HH:mm:ss as its value. Now, this has some very obvious uses such as storing the date a migration was executed into your database. However, there is something more complex... Read more

Annabel Bradford

19 March 2020

Annabel Bradford

19 March 2020

There’s no place like home to join us at Redgate Streamed

Redgate is closely monitoring developments related to the COVID-19 outbreak and has already put in place measures to ensure the safety of our employees while still fully supporting our customers. We back the decision many conference organisers have made, by postponing their events until later in the year or switching them to virtual events.... Read more