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.”
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
Case study
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
Whitepaper
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
Solution brief
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 articlePricing 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.
If you only need to provision or mask a subset of a 10TB database, you either need a 10TB license, as this is the size of the production database, or to subset out the data you want to work with into a separate database before using SQL Provision.
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.
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'.
Compliant Database DevOps
Standardize team-based development
Automate database deployments
Monitor performance and availability
Protect and preserve data
