IT consultancy, sqlity.net, specializes in helping organizations get the best performance and business value from their SQL Server estates through Data Platform DevOps. The founder, Sebastian Meine, is also one of the co-creators of tSQLt, the only open source unit testing framework to enable true continuous integration and continuous delivery for SQL Server. We recently […] Read more
Imagine a world without the open source database migrations tool, Flyway. Migration scripts being run in the wrong order, changes getting overwritten, having to dump hours of work because you started with an out-of-date version. Flyway is so popular today because it sorts out the issue of database migrations in such a simple and elegant […] Read more
Often when working with Flyway (and release automation in general) you will have a set of deployables - and a chain of environments these need to be delivered to in order. Read more
Until now the only way to configure Flyway has been through plaintext configuration parameters such as in a Flyway configuration file, through the command-line or by setting environment variables. As your organizations and enterprises grow and more people interact with your processes you’ll inevitably want a way to secure as much information as possible, such […] Read more
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 Flyway […] 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 in […] Read more
We’ve had some users ask recently about multi-schema deployments. There are a number of possible scenarios, some of which are supported naturally by Flyway and some not. This blog post summarises the current state of play on the matter, but we’re keen to make sure we cover popular use cases. If you have any feedback […] Read more
18 months ago, Flyway was acquired by Redgate. It’s been quite a ride since then and we thought we’d end 2020 with an update on what’s been happening with the world’s most popular open source migrations framework for database deployments. We’ve learned a lot, and I wanted to share that with you in this post. […] Read more
Have you ever wanted more customizable control over when your migrations are executed? In Flyway Teams Edition 7.3.0 we released the shouldExecute script configuration option which lets you achieve just that! What is the shouldExecute option? shouldExecute is a new script configuration option, and if you aren’t already familiar with this concept you can read about it here. With […] Read more
Flyway 7.3.0 is out! This release contains new features and improvements over Flyway 7.2.0. Highlights A placeholder for the full filename of a migration file Script config files can specify shouldExecute Retrying connections back off exponentially Dry Run output can be directed to AWS S3 or Google Cloud Storage You can find a detailed list of the […] Read more
