Case Study: a global, science-led pharmaceutical company accelerates scientific discovery with Redgate Flyway

Unlocking the speed to scientific discovery with Redgate Flyway

A global, science-led pharmaceutical company faced a significant challenge in managing the database schemas for its Genomics Research Analysis Platform. As the team and data grew to over 500 schemas, maintaining consistency across test, pre-production, and production environments became a complex, error-prone, and manually intensive process. The vendor, Redgate, with its product Flyway, was identified as a solution to mitigate these risks and automate their schema management.

Implementing Redgate Flyway provided an automated and standardized method for managing database changes through their CI/CD pipeline. The solution delivered dramatic results: a process that previously took five days and 20 hours of hands-on work was reduced to under one day with less than two hours of manual effort. This provided the team with peace of mind, guaranteed consistency across all environments, and notably boosted the speed of scientific discovery for the wider organization.