Redgate Test Data Manager

Improve your release quality and reduce your risk, with the flexibility to fit your workflow

Redgate Flyway

Automate database deployments across teams and technologies

Redgate Monitor

Understand server performance in an instant with fast deep-dive analysis

See all our products

Overview

Redgate’s end-to-end Database DevOps solutions

Protect

Reliable test data management, automating repetition out of the process

Automate

Automate and accelerate your database change management workflow

Monitor

Monitor your cross-database, multi-platform estate to ensure optimal performance

SQL Provision

Provision virtualized clones of databases in seconds, with sensitive data masked

  • Agility – Automate or self-serve development, test, and CI environments in seconds
  • Quality – Ensure the reliability and accuracy of development and testing
  • Control – Support compliance and scale with ease with centralized access controls
Request a demo

Reader's Choice Gold Award

Visual Studio Magazine 2019

SQL Provision enables teams to improve application releases, optimize the developer experience, accelerate database provisioning, and secure data to scale confidently.

SQL Provision combines our data virtualization and data masking capabilities to provision virtualized clones of databases, at speed, with sensitive data shielded, empowering teams to streamline their development and testing processes

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

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.

Refresh Dev, Test and CI in seconds

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.

Unblock dedicated database development

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.

Not sure where to start? SQL Data Catalog helps you identify and classify sensitive data, integrating with Data Masker to ease the burden of regulatory compliance.

Mask sensitive data for compliance

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 teams to improve application releases, optimize the developer experience, accelerate database provisioning, and secure data to scale confidently.

“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.”

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

Bloor Market Update 2024

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

Get the Bloor Market Update
The Cover for the Bloor InBrief: Redgate Test Data Manager 2024 report

Bloor InBrief: Redgate Test Data Manager 2024

“If Redgate Test Data Manager is an option for your environment, you should be considering it.” – Bloor Analyst.

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 25 years

Redgate has specialized in database software for 25 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'.

Monthly newsletter

Join over 150,000 data professionals

Get the latest best practices, insight, and product news from our industry experts

Get the newsletter