Reader's Choice Gold Award
Visual Studio Magazine 2019
"We’ve cut the time for database provisioning by more than 85%, which is a really quick win for us."
Refresh every stage of your development process in seconds with sanitized production data.
Catch data-related issues early and enjoy high release success. Automate test data provisioning or enable self-service so development teams can refresh environments on demand.
Protect sensitive data subject to GDPR, HIPAA, CCPA, and other regulations with masking.
Deliver sanitized production data to development, test, and continuous integration environments quickly. Secure your business in the event of a data breach and maintain compliance without slowing development down.
The small footprint that clones need allows developers to create multiple local copies without placing a demand on infrastructure teams.
Built-in controls for teams boost productivity and integrated masking ensures data security. Developers are free to self-serve a copy of the database they need, on-demand and pre-configured with data matched to their project and security clearance.
Dedicated database environments for development, test, and CI set the foundation for Compliant Database DevOps.
As DevOps scales through your organization, it drives the alignment of database and application teams. But while agile methodologies have brought greater velocity to application development, database development cycles remain slow in comparison.
SQL Provision enables software teams to deliver database environments at the speed required by DevOps, while ensuring the security of sensitive data subject to GDPR, HIPAA, CCPA, and other regulations.
“We've cut the time for database provisioning by more than 85%, which is a really quick win for us.”
“A big win for us is giving each developer the freedom to work on their own database.”
“The database is not sitting there exposed, it never goes out with the PHI in it. There's no way I could do that in any other way as easily as I can with SQL Provision.”
“The team didn’t notice any difference between working with a real database and a clone.”
|Virtualize – refresh environments in seconds and save 99% storage|
Create virtualized clones of SQL Server databases on premises or in virtual machines within a cloud environment such as Amazon Web Services (AWS) or Microsoft Azure.
Clones work just like normal databases but are tiny in size, saving up to 99% disk space. This means that full and accurate copies of production datasets can be spun up in seconds for development, testing, and continuous integration.
|Protect – deliver production-like data while ensuring compliance|
Mask data subject to regulations such as GDPR, CCPA, HIPAA, and others.
Developers receive data that accurately reflects the production environment's nuanced structure, complexity, and referential integrity, driving up the quality and reliability of database updates.
|Automate – create and refresh environments on demand|
Refresh development, test, and CI environments with fresh, sanitized production data as fast as software updates are released.
A library of PowerShell commands makes integration with build, release, and CI systems seamless and opens new opportunities for automated test data provisioning and database continuous delivery.
|Self-service – enable developers to self-serve fresh data|
Precise control over which databases specific users and teams can use to create clones and images enables safe self-service.
Developers are free to pull a copy of the instance they need, on-demand and pre-configured with data matched to their project and security clearance.
|Manage – single UI for managing database clones and permissions|
Manage all provisioning tasks from a single UI. See what clones have been created, how much disk space they’re using, when they were created, and by who.
Control who is able to create clones and images from which database instances, enabling safe self-service and delegation for DevOps and continuous integration.
Use this guide to understand the key capabilities offered by vendors in the Test Data Management market, including Redgate.Get the Bloor Market Update
"SQL Provision and SQL Data Catalog together provide a complete test data management solution that includes test data discovery, masking, and provisioning (via database clones) and can readily enmesh itself into your existing processes." Bloor Analyst.Get the Bloor InBrief research
PASS included SQL Provision as part of their Database DevOps implementation to speed up the delivery of test data to dedicated development environments while reducing their compliance risk.Read the case study
As database teams grapple with shortening release cycles and tightening data protection laws, the need to deliver realistic and compliant test data to development quickly and safely is greater than ever.
Review the most common approaches and their pros and cons in this free whitepaper.Get the whitepaper
Download this solution brief to learn how SQL Provision unblocks dedicated database environments to speed up software development while ensuring the security of sensitive data and meeting compliance targets.Read the solution brief
Tony Davis explains how SQL Provision helps to accelerate the delivery of database changes.Read the article
James Murtagh looks at the working practices and tools that allow teams to move to a dedicated development model.Read the article
Pricing is based on the total volume of data in all production databases that you would like to provision or mask from, and the length of your subscription. More info
To provision a 2TB database you need a 3TB capacity license of SQL Provision. Licensing is based on tiers and the 3TB tier allows you to provision data up to 3TB.
To provision a 1TB database and mask 500GB of data from the same database, you only need a 1TB license of SQL Provision.
If you have five production databases with different schemas, each 1.5TB in size (a total of 7.5TB of data), you would need a 10TB capacity license of SQL Provision to provision or mask all your databases.
To provision from a 3TB production database, and backups at different points in the database's history, you only need a 3TB tier license. This is because you are provisioning from the same database at different points in its life.
1 Year Subscription
1 Year Subscription
Contact us for a
Whether you want more details about SQL Provision, a demo, or to know about best practice – get in touch.
Redgate has specialized in database software for 20 years. Our products are used by 804,000 IT professionals, in more than 100,000 companies.
Redgate offers comprehensive documentation and a friendly, helpful support team. An average 87% of customers rate our support 'Excellent'.