Case Study: Hays Travel achieves safer, error-free database deployments with Redgate SQL Toolbelt Essentials

Hays Travel cuts weekly deployment incidents with Redgate Software

Hays Travel, the UK's largest independent travel agent, faced significant challenges in managing database deployments for its critical business applications. Using a typical Microsoft stack, the team struggled with failed weekly deployments due to a lack of version control for SQL and unmanaged hotfixes directly in live environments. This disrupted business operations. Redgate Software was approached to help refine their development process.

By implementing Redgate's SQL Toolbelt Essentials, specifically SQL Source Control and SQL Compare, the team gained proper version control and accurate schema comparison between test and live environments. The solution eliminated deployment errors and gave the team confidence. Additional tools like SQL Prompt and SQL Search dramatically sped up development time. The result was a streamlined, error-free release process that resolved all previous deployment issues and energized the team's approach to database development.

Hays Travel