Case Study: Bennetts improves code quality and reduces deployment errors with Redgate SQL Toolbelt Essentials

Improved code quality, reduced deployment errors, and increased productivity

Bennetts, one of the UK's leading motorcycle insurance brokers, faced significant challenges with its large, complex legacy database. Their manual deployment process was slow, prone to errors, and lacked source control, leading to frequent failures that took days to fix and could negatively impact their live customer-facing applications. The technical team, led by Redgate's customer, was burdened by a cumbersome process that severely limited their productivity.

To solve this, the team implemented Redgate's SQL Toolbelt Essentials, a suite of tools including SQL Prompt, SQL Compare, and SQL Data Compare. This solution automated and standardized their code formatting, enabled swift rollbacks, and provided robust comparison functionality. As a result, Redgate helped Bennetts drastically reduce deployment errors and failures, significantly increase developer productivity, and streamline their processes. These efficiency gains freed the team to focus on their larger goal of modernizing the entire legacy database infrastructure.

Bennetts

Ryan Hird

Technical Lead