Flyway can validate your migrations according to its own conventions, giving you the confidence you need to apply new migrations. However, as the lifetime of a project increases, there will inevitably be hotfixes, deleted migrations and other changes that break the conventions of Flyway’s validation. In these cases you need a way to tell... Read more
“It worked on my machine“. You’ve likely either heard this from a colleague or thought this yourself when a Flyway migration failed during a production deployment. The fact is that unfortunately, bad migrations slip through to the release process despite our best efforts. Thankfully, there are solutions to this – testing your Flyway migrations... Read more
The ultimate goal for automating deployments can be the hands-free deployment of all code, including the database, from development to production. However, for many of us, the complete automation of all deployments with zero manual intervention will always remain a goal. We may have systems that are simply too complex for a 100% automated... Read more
What are candidate keys? How do you check if a set of attributes is a candidate key? Read on to find the answers and see real-world examples. Read more
My blog post from February 1 explains that Redgate took the opportunity to purchase the assets of PASS with the main goal of supporting the community. The PASS association ran for 21 years bringing together a community to connect, share, and learn. The community of course lives on, however the association no longer exists... Read more
This question was raised at the recent Redgate Summit: How does the implementation of a microservices architecture affect the implementation of a database DevOps approach? I could even rephrase it a little: Does a microservices architecture affect a database DevOps approach? Microservices is, or isn’t, one of the hot new trends, depending on how... Read more