Case Study: Desjardins standardizes database migrations and speeds deployments with Redgate Flyway

Standardizing migrations across teams and multiple database types with Flyway

Desjardins, the leading financial cooperative in North America, faced a significant challenge standardizing and tracking database deployments across its complex, multi-database estate, which included Oracle, SQL Server, and PostgreSQL. With hundreds of databases and numerous development teams, it was difficult to manage who was deploying changes and when, slowing down their development process and increasing the risk of errors.

The vendor, Redgate, provided its Flyway Teams Edition to address this. The solution standardized the creation and versioning of migration scripts across all database types, integrating them into the CI/CD pipeline. This automation allowed Desjardins to increase deployment frequency to up to 40 times per day, significantly reduce errors, and gain full visibility into the deployment state of every environment through Flyway's audit trail and history table.

Desjardins