Case Study: Paymentsense cuts database provisioning time by 85% with Redgate SQL Clone

Paymentsense - Customer Case Study

Paymentsense, the UK's largest merchant services provider, faced a significant challenge with its database provisioning process. The existing method was brittle, time-consuming, and caused major disk space issues. This hindered their DevOps workflow, as developers often had to wait for database copies and sometimes could only test with small sample data that did not accurately reflect production, leading to unexpected issues. They turned to Redgate for a solution using its SQL Clone product.

By implementing Redgate's SQL Clone, Paymentsense automated its provisioning. The solution creates a data image from a nightly backup and then provisions multiple clones for developers on demand in seconds. This cut database provisioning time by more than 85% and eliminated the disk space problem, with each clone using only about 40MB. The result is a more efficient and accurate development process where teams can test against full, realistic copies of production data.

Paymentsense

Ahmed Althamari

Senior SQL Server DBA