Redgate SQL Provision
red-gate.com
- Free trial
- Windows
- Linux
- Web
- Self-hosted
What Redgate SQL Provision is
Redgate SQL Provision creates virtualized Microsoft SQL Server database copies for development, testing, and continuous integration. It combines SQL Clone with Data Masker for SQL Server, so teams can automate environment creation and refreshes or let developers request fresh data themselves. A single interface manages clones and permissions, while integrated masking is intended to shield sensitive information outside production. Redgate says masking 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 self-hosted, web, and desktop deployment options. Licensing tiers depend on combined production database volume to provision or mask, from 1TB to 100TB; customers whose volume falls between tiers must purchase the next higher tier. Capacity is reviewed every 12 months after a subscription begins. Pricing is on request, there is no free plan, and Redgate offers a 14-day fully functional trial. Redgate is based in Cambridge, United Kingdom.
Who it suits
It is aimed at software teams that need dedicated SQL Server environments for development and testing. Teams needing masked copies, automated refreshes, or developer self-service may find its workflow relevant.
Good to know, and what to watch
- Creates virtualized copies for development and testing
- Integrated masking targets sensitive non-production data
- Automates environment creation and refreshes
- Single interface manages clones and permissions
- Offers a 14-day fully functional trial
- No free plan is listed
- Pricing is on request
- Users between capacity tiers must buy the next tier
- Capacity is reviewed every 12 months
Plans
Every plan and priceSQL Provision
Pricing on request
Getting started
- Visit the Redgate SQL Provision website.
- Request pricing for the applicable production data-volume tier.
- Start the 14-day fully functional trial.
- Use the web or desktop deployment, or choose the self-hosted option.
- Combine SQL Clone and Data Masker for SQL Server to provision and mask database copies.
Limits to check
There is no free plan; the available trial lasts 14 days. Paid licensing uses production-volume tiers from 1TB to 100TB, and volumes between tiers require the next higher tier; capacity is reviewed every 12 months after the subscription begins.
The Club's review
Redgate SQL Provision combines virtualized SQL Server copies with data masking for teams building development, test, and CI environments. It is strongest for organizations that need repeatable access to production-shaped data while controlling exposure of sensitive records. Its rapid refreshes and automation are compelling, but the production-volume licensing model makes capacity a central buying consideration.
Overview
SQL Provision brings SQL Clone and Data Masker for SQL Server into one product. Teams can automate environment creation and refresh, or let developers request fresh data on demand; a single interface manages clones and permissions. That combination can reduce provisioning bottlenecks while giving teams a more consistent way to supply dedicated non-production databases.
Redgate advertises refreshes in seconds and storage savings of up to 99%. Those are meaningful potential gains for teams with many environments or frequent refresh cycles, though actual savings depend on usage. Integrated masking is intended to shield sensitive data outside production. Redgate says it can help protect data covered by GDPR, HIPAA, CCPA, and other regulations; it is a data-protection measure, not a compliance guarantee.
Key features
- Virtualized copies and refresh: SQL Provision is designed to make dedicated databases practical without maintaining a full duplicate for every developer or test cycle. The advertised speed and storage savings are particularly relevant to teams refreshing environments often.
- Automation and self-service: Teams can automate creation and refresh, while developers can request fresh data when needed. This can reduce routine setup work for database administrators, although organizations still need to govern who can provision and access clones.
- Masking in the workflow: Masking is integrated with the copy-provisioning product, so teams can address sensitive data as they prepare non-production environments rather than treating it as a separate concern.
- Database administration capabilities: The product supports SQL Server and includes automated provisioning, roles and permissions, audit logging, restore verification, rollback, schema comparison, drift detection, CI/CD automation, and query analysis such as profiling, execution plans, and wait and lock analysis. This broad toolset may suit database teams coordinating changes and troubleshooting alongside provisioning, but SQL Provision remains focused on Microsoft SQL Server rather than a mixed-engine estate.
- Support: Redgate provides documentation and a support team, and says an average 87% of customers rate its support excellent. That may reassure teams planning to rely on provisioning as part of a regular delivery process.
Pricing
SQL Provision is paid software with custom pricing; there is no free plan. Redgate offers a 14-day fully functional free trial, giving teams a defined period to assess whether its workflow fits their SQL Server environments.
The SQL Provision plan is organized into capacity tiers of 1TB, 3TB, 5TB, 10TB, 20TB, 50TB, and 100TB, based on total production data volume to provision or mask. Licensing uses combined production database volume, and a customer between tiers must buy the next higher tier. The subscription also calls for a capacity true-up every 12 months after it begins. This structure is most consequential for organizations near a tier boundary or expecting production data to grow; teams should establish their relevant volume before estimating the required tier.
Platforms
SQL Provision is for Microsoft SQL Server, with Linux, Windows, web, and self-hosted platform support. Its deployment model includes desktop and web-and-desktop use. It is not a general-purpose database provisioning choice for teams whose non-production work spans other database engines.
Who it's for
SQL Provision is a strong fit for software teams that need fast, dedicated SQL Server environments for development, testing, and continuous integration, especially when production data needs masking before it moves into non-production use. Teams that want developers to obtain refreshed data without routing every request through a central administrator may also benefit from its self-service model.
It is a weaker fit for small projects that need a free tool, teams seeking a published fixed price, or organizations provisioning across several database engines. Its capacity tiers can also be awkward when production volume sits just above a threshold, since the next tier is required.
Pros and cons
- Pro: Virtualized copies, rapid refreshes, and advertised storage savings target the cost and delay of maintaining multiple full database environments.
- Pro: Integrated masking and clone permissions bring data protection and access management into the provisioning workflow.
- Pro: Automation and developer self-service support repeatable environment setup for development, test, and CI teams.
- Con: SQL Server-only coverage rules it out for teams that need a cross-database provisioning platform.
- Con: Custom pricing and volume-based tiers make budget estimates less direct, particularly when a team falls between tiers or anticipates growth.
- Con: There is no free plan, and the 14-day trial is the only stated no-cost evaluation route.
Alternatives
For teams comparing database tools, the Database Schema Comparison Tools directory is relevant when schema comparison is the main need, while Database Administration Tools covers broader administration choices. Readers focused on query and workload visibility can browse Database Performance Monitoring Software; those prioritizing protection can review Database Security Software or Code Obfuscation Software. The Test Data Management Software directory is the closest category match for teams evaluating non-production data workflows.
Among specific tools, choose dbForge Studio for PostgreSQL when PostgreSQL-oriented database work and a freemium plan matter more than SQL Provision's SQL Server provisioning focus. Skeema is a better fit for teams seeking a freemium schema workflow: its Community plan is free and its Plus plan costs $124 a month, but it is not presented as a SQL Server copy-and-masking product. Consider SQL Delta or SQL DXP when a Windows-based database comparison tool is the priority rather than provisioning and masking. For a free, open-source schema-diff option, sqldef is a Linux, macOS, self-hosted, and Windows CLI tool; apgdiff is a free PostgreSQL schema diff tool, and pgquarrel is a free BSD-3-Clause-licensed option. dbdiff is another free alternative for teams comparing database schemas.
Verdict
Choose Redgate SQL Provision if your team provisions SQL Server development, test, or CI databases regularly and wants virtualized copies, integrated masking, and automated or self-service refreshes in one workflow. Its central advantage is making repeatable, protected non-production environments easier to supply. Look elsewhere if you need multiple database engines, a free plan, or pricing that can be estimated without first resolving production-volume capacity.
The verdict
SQL Provision brings database copying and masking together for non-production work. Its volume-based tiers and required capacity review are important considerations when estimating fit.
Questions people ask
Does SQL Provision have a free plan?
No. Redgate offers a 14-day fully functional free trial.
How much does SQL Provision cost?
Pricing is on request. Licensing tiers are based on combined production database volume, from 1TB to 100TB.
Which database does it support?
SQL Provision supports Microsoft SQL Server and combines SQL Clone with Data Masker for SQL Server.
Can SQL Provision be self-hosted?
Yes. It supports a self-hosted option as well as web and desktop deployment.
What happens if our data volume is between licensing tiers?
The licensing model requires customers between tiers to buy the next higher tier. Capacity is reviewed every 12 months after a subscription starts.
What the maker publishes
- Automation
- Teams can automate creation and refresh of environments or let developers self-serve fresh data on demand. source
- Capacity limit
- Licensing tiers are based on combined production database volume, and users between tiers must buy the next higher tier. source
- Capacity review
- The capacity model calls for a true-up every 12 months after the subscription begins. source
- Company location
- Redgate lists its Cambridge office at Cambridge Business Park in the United Kingdom. source
- Compliance
- Redgate says masking can help protect data subject to GDPR, HIPAA, CCPA, and other regulations. source
- Founded
- 1999 source
- Founded
- 1999 source
- Founded
- 1999 source
- Founded
- 1999 source
- Founded
- 1999 source
- Founded
- 1999 source
- Founded
- 1999 source
- Founded
- 1999 source
- Founded
- 1999 source
- Headquarters
- Cambridge, United Kingdom source
- Headquarters
- Cambridge, United Kingdom source
- Headquarters
- Cambridge, United Kingdom source
- Headquarters
- Cambridge, United Kingdom source
- Headquarters
- Cambridge, United Kingdom source
- Headquarters
- Cambridge, United Kingdom source
- Headquarters
- Cambridge, United Kingdom source
- Headquarters
- Cambridge, United Kingdom source
- Headquarters
- Cambridge, United Kingdom source
- Headquarters
- Cambridge, United Kingdom source
Checked against the maker's pages on 29 Sept 2026.