Case Study: Santam achieves 720x faster data provisioning with Redgate SQL Provision

From hours to seconds Provisioning data 720 times faster

Santam, South Africa's leading general insurer, faced a significant challenge in provisioning test data for its 13 development teams. Their process, dependent on database administrators manually restoring from backups, was slow, taking up to two days for a full refresh and creating a major bottleneck. This hindered their Agile development process and compliance with data privacy regulations due to the use of unsanitized data.

Redgate addressed this with its SQL Provision solution. The tool automated and secured the delivery of test data, allowing teams to create sanitized, virtual clones of production databases in seconds instead of hours. This implementation by Redgate enabled Santam to provision data 720 times faster, reduced storage space by 95%, and gave development teams the self-service capability to work with compliant data, dramatically accelerating their release cycles and improving software quality.

Santam

Mark Fuller

IT Development Manager