Case Study: Bennetts achieves faster database development with Redgate SQL Clone

Moving to a dedicated database development model

Bennetts, a specialist motorbike insurance broker, faced development delays caused by its team of 12 all working on a single shared test database. This led to frequent conflicts and a long development queue. The existing process to create individual databases for developers via backup-and-restore was too slow and resource-intensive, taking an hour to set up a single 15 GB database, which proved to be a major blocker to productivity.

The vendor, Redgate, provided its SQL Clone solution. This tool allowed Bennetts to create lightweight copies, or clones, of their database in seconds, using minimal disk space on local machines. The result was the elimination of developer conflicts and a dramatically faster provisioning process, which Redgate's product automated. This empowered each developer to work on their own dedicated database copy, significantly improving team productivity and the speed of delivering changes.

Bennetts

Ryan Hird

Technical Lead