Voice of the DBA

Migrations are Worth the Effort

12.18.2023 - By Steve JonesPlay

Download our free app to listen on your phone

Download on the App StoreGet it on Google Play

I work with a lot of customers that are trying to find better ways to build and deploy database code. Some of them use a state or model method with SQL Compare or another Redgate product, and some want to use Flyway and its hybrid migration-based framework. It's always interesting to me how customers lean one way or the other, for various reasons. No matter which choice people make, we know that using migrations is more effort than a state-based approach. However, I think that it's a better approach, especially because no matter how simple or smooth you think your development process is, at some time there will be a situation that needs a more complex approach. a migrations-based framework allows you to handle the complexity smoothly, without depending on a person to sort out the issues. Read the rest of Migrations are Worth the Effort

More episodes from Voice of the DBA