Accelerate the delivery of database environments for DevOps teams

  • Speed - Refresh development, test, and CI environments in seconds
  • Risk - Mask data subject to GDPR, HIPAA, CCPA, and other regulations
  • Space - Shrink TB-sized databases to tens of MBs
  • Quality - Catch issues early and improve release success
  • Control - Manage database provisioning from a single UI
Request a demo

Reader's Choice Gold Award

Visual Studio Magazine 2019

SQL Provision combines SQL Clone and Data Masker for SQL Server to enable software teams to deliver database environments at the speed required by modern development practices, 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."

Ahmed Althamari, Senior SQL Server DBA, Paymentsense
Paymentsense logo

Read the case study

Benefits

Refresh dev, test, and CI in seconds

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.

Mask sensitive data for compliance

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.

Unblock dedicated database development

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.

Compliant Database DevOps

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.

Key features

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.

Analyst insights

Gartner Market Guide

Gartner has published its 2018 Market Guide for Data Masking. You can use this guide to understand the key capabilities offered by vendors in this market, including Redgate.

Get the Gartner Market Guide

Bloor Market Update

Use this guide to understand the key capabilities offered by vendors in the Test Data Management market, including Redgate.

Get the Bloor Market Update

Bloor InBrief: SQL Provision

Redgate provides software that enables what it calls ‘Compliant Database DevOps’, meaning that it helps you to leverage your data inside a DevOps toolchain in a way that is compliant with all applicable regulations and policies.

Get the Bloor InBrief research

Further resources

Case study

The Benefits of Adopting Compliant Database DevOps at PASS

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

Test data provisioning for development

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

Dedicated database environments for development, test, and CI

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

The Database DevOps challenges SQL Provision solves

Tony Davis explains how SQL Provision helps to accelerate the delivery of database changes.

Read the article

From shared to dedicated database development

James Murtagh looks at the working practices and tools that allow teams to move to a dedicated development model.

Read the article

We're here to help 01223437921

Whether you want more details about SQL Provision, a demo, or to know about best practice – get in touch.

The industry standard tools for 20 years

Redgate has specialized in database software for 20 years. Our products are used by 804,000 IT professionals, in more than 100,000 companies.

World-class support

Redgate offers comprehensive documentation and a friendly, helpful support team. An average 87% of customers rate our support 'Excellent'.