Redgate SQL Provision

What Redgate SQL Provision is

Redgate SQL Provision combines SQL Clone and Data Masker for SQL Server to create virtualized database copies with sensitive data masked. It is intended for development, test, and continuous integration environments. Teams can automate creating and refreshing environments, or let developers request fresh data on demand; a single interface manages clones and permissions. Integrated masking is intended to shield sensitive information in non-production environments, and Redgate says it can help protect data subject to GDPR, HIPAA, CCPA, and other regulations. The product advertises refreshes in seconds and storage savings of up to 99%. It supports Microsoft SQL Server and lists self-hosted, web, and desktop deployment options. Licensing tiers depend on combined production database volume to provision or mask, with tiers from 1TB to 100TB. Customers whose volume falls between tiers must buy the next higher tier, and capacity is reviewed every 12 months after a subscription begins. Pricing is on request; there is no free plan, but Redgate offers a 14-day fully functional free trial.

Who it suits

SQL Provision suits software teams that need dedicated database environments for development and testing. It may fit teams that want to automate provisioning or let developers request fresh data themselves.

Limits

There is no free plan; the trial lasts 14 days. Licensing tiers run from 1TB to 100TB of combined production data volume, and volumes between tiers require purchase of the next higher tier. Capacity is reviewed every 12 months after the subscription begins.

Getting started

1. Visit the Redgate SQL Provision product page.
2. Start the 14-day fully functional free trial or contact Redgate about pricing.
3. Select the licensing tier based on the combined production data volume to provision or mask.
4. Choose a deployment option: self-hosted, web, or desktop.
5. Use SQL Clone and Data Masker for SQL Server to provision copies and mask non-production data.
6. Set up automated refreshes or let developers request fresh data on demand.

Verdict

SQL Provision is focused on virtualized SQL Server copies and masking for non-production use. Check the volume-based tiers and review cycle when assessing fit.