Redgate Launches SQL Provision
January 18, 2018

Redgate Software launched SQL Provision, which allows users to create copies of SQL Server databases in seconds which use a fraction of disk space, and mask any sensitive data to address data privacy and protection issues.

The provisioning of database copies to improve the efficiency and quality of database development and testing is becoming increasingly common as companies and organizations seek to introduce DevOps practices. Working with a copy of the production database enables developers to find errors faster and prevents problems when changes are deployed.

It does, however, take a long time and huge amounts of disk space to provision copies, so old copies are often used, which become increasingly unreliable over time and are difficult to keep track of, especially where multiple developers are involved. Coupled with this, the implementation of the GDPR in May 2018 is making the protection of sensitive data a priority for almost every company and organization.

SQL Provision has been created to support a database DevOps approach while keeping GDPR compliance central to the process. Using Data Masker, sensitive data can be anonymized or replaced with realistic data, helping to satisfy the requirements of regulations like GDPR, HIPAA and SOX. The virtual cloning technology of SQL Clone can then create full database copies in seconds using just a few MB of local disk storage, giving developers a truly realistic copy, while keeping confidential data protected.

The masking and provisioning of database copies is also managed from one place, so organizations can control their distribution and know when copies were provided, to which developers or teams of developers, and the precise data that was masked.

“The closer we get to GDPR, the bigger the issue of data privacy becomes,” says Richard Macaskill, Redgate Product Manager. “Companies need solutions that free them to take advantage of DevOps in their database development process, yet enable them to be truly compliant.”

This is particularly important because Redgate’s recent SQL Server Database Provisioning Report found that 83% of respondents agreed or strongly agreed that it is desirable to use production data in development and testing. With SQL Provision, they can continue to do so, knowing that data security, regulatory compliance and storage concerns have been accommodated.

Redgate has also deliberately priced SQL Provision so that small and medium sized enterprises can take advantage of it alongside large corporations. The tiered pricing model is based on the total size of the databases organizations need to provision, rather than the number of users.

As Richard Macaskill concludes: “Provisioning solutions have typically been restricted to big companies in the past. Every company and organization of whatever size will need to comply with the GDPR, so it makes sense to give them the opportunity to do so.”

The development teams behind Data Masker and SQL Clone which comprise the SQL Provision solution are continuing to refine the tools to streamline data masking and database provisioning yet further.

Share this

Industry News

October 03, 2022

Spectro Cloud announced a major new release of its Palette Edge platform.

October 03, 2022

Arcion announced agentless change data capture (CDC) for all of its supported databases and applications.

September 29, 2022

CloudBees announced the acquisition of ReleaseIQ to expand the company’s DevSecOps capabilities, empowering customers with a low-code, end-to-end release orchestration and visibility solution.

September 29, 2022

SmartBear continues expanding its commitment to the Atlassian Marketplace, adding Bugsnag for Jira and SwaggerHub Integration for Confluence.

Bugsnag developers monitoring application stability and documenting in Jira no longer need to interrupt their workflow to access the app. Developers working in SwaggerHub can use the macro to push API definitions and changes directly to other teams and business stakeholders that work within Confluence. By increasing the presence of SmartBear tools on the Atlassian Marketplace, the company continues meeting developers where they are.

September 29, 2022

Ox Security exited stealth today with $34M in funding led by Evolution Equity Partners, Team8, and M12, Microsoft's venture fund, with participation from Rain Capital.

September 29, 2022

cnvrg.io announced that the new Intel Developer Cloud is now available via the cnvrg.io Metacloud platform, providing a fully integrated software and hardware solution.

September 28, 2022

Kong introduced a number of new performance, security and extensibility features across its entire product portfolio, including major new releases of Kong Gateway, Kong Konnect, Kong Mesh, Kong Insomnia and Kong Ingress Controller, as well as new projects from the Kong Incubator.

September 28, 2022

BroadPeak Partners announced the availability of the new K3 API Connector.

September 28, 2022

Aqua Security announced a new end-to-end software supply chain security solution.

September 27, 2022

DevOps Institute will host SKILup Festival in Singapore on November 15, 2022.

September 27, 2022

Delinea announced the latest release of DevOps Secrets Vault, its high-speed vault for DevOps and DevSecOps teams.

September 27, 2022

The Apptainer community announced version 1.1.0 of the popular container system for secure, high-performance computing (HPC). Improvements in the new version provide a smaller attack surface for production deployments while offering features that improve and simplify the user experience.

September 26, 2022

Secure Code Warrior unveiled Coding Labs, a new mechanism that allows developers to more easily move from learning to applying secure coding knowledge, leading to fewer vulnerabilities in code.

September 26, 2022

ActiveState announced the availability of the ActiveState Artifact Repository.

September 26, 2022

Split Software announced the availability of its Feature Data Platform in the Microsoft Azure Marketplace.