Redgate Software Upgrades SQL Clone Database Provisioning Solution
August 13, 2019

As DevOps scales through organizations, the database is increasingly being included as a natural part of the development process. As a consequence, more developers in more teams want copies of the database to test their changes against, and Redgate Software has upgraded its database provisioning solution, SQL Clone, to give teams faster, easier access to the copies they need.

SQL Clone uses the virtualization technologies built into the Windows OS to create database copies, or clones, which are a fraction of the size of the original – typically 40MB for a 1TB database. The clones can be provisioned in seconds to developers and, despite their small footprint, look, behave and work just like the original.

Different teams, however, will have varying requirements, based on the type of data inside the database copies, its level of sensitivity, and regulations like the GDPR, CCPA and HIPAA which need to be complied with.

The new Teams feature in SQL Clone 4 directly addresses this issue by allowing Database Administrators (DBAs) and Data Architects to have more control over the instances, images and clones that developers have access to, enabling safe self-service and delegation for DevOps and CI.

Using Windows Active Directory groups, DBAs can now grant individual teams clearance to view and use specific instances and images and the clones associated with them. Only they will be able to see them and, similarly, they will not have access to the copies in use by other teams.

Importantly, this allows developers working on different projects to be able to self-serve their database copies, and refresh dedicated development environments on-demand. It also fulfils a requirement for DevOps identified by the analyst house, Bloor Research, in a 2019 InBrief: “Timely provisioning of test data – delivering the right test data to the right place at the right time – is an important component of any DevOps pipeline.”

As James Murtagh, Redgate Product Marketing Manager, comments: “With more database environments being created to drive dedicated development and continuous integration pipelines, there’s now a need to provision test data more efficiently. At the same time, though, the question of data privacy has to become business as usual and without the right tooling and approach, it will hamper digital transformation initiatives.”

He goes on to add: “SQL Clone’s new Teams feature enables DevOps teams to self-serve not only safe data, but the precise data related to their particular project. That helps them boost efficiency (it’s what DevOps is all about, after all), and progress DevOps and agile development methods hand-in-hand with privacy regulations.”

Share this

Industry News

July 09, 2020

ShiftLeft released a new version of NextGen Static Analysis (NG SAST), including new workflows, purpose-built for developers that significantly improve security, while enhancing productivity.

July 09, 2020

RunSafe Security announced a partnership with JFrog that will enable RunSafe to supercharge binary protections via a simple plugin that JFrog users can deploy within their Artifactory repositories and instantly protect binaries and containers.

July 09, 2020

LeanIX closed $80 million in Series D funding led by new investor Goldman Sachs Growth.

July 08, 2020

Afi.ai introduced Afi Data Platform, a cloud-based replication and resiliency service that helps to monitor, predict downtime and recover K8s applications.

July 08, 2020

D2iQ announced the release of Conductor, a new interactive learning platform that enables enterprises to access hands-on cloud native courses and training.

July 08, 2020

SUSE entered into a definitive agreement to acquire Rancher Labs.

July 07, 2020

Micro Focus announced AI-powered enhancements to the intelligent testing capabilities of the UFT Family, a unified set of solutions designed to reduce the overall complexity of automating the functional testing processes.

July 07, 2020

Push Technology announced the launch of a new Service API capability for Diffusion Cloud, Push’s Real-Time API Management Cloud Platform.

July 07, 2020

Lightrun exited stealth and announced $4M in seed funding for the first complete continuous debugging and observability platform for production applications.

July 01, 2020

JFrog announced the launch of ChartCenter, a free, security-focused central repository of Helm charts for the community.

July 01, 2020

Kong announced a significant upgrade to open source Kuma, Kuma 0.6, available today.

July 01, 2020

Compuware Corporation, a BMC company, announced new capabilities that further automate and integrate test data and test case execution, empowering IT teams to achieve high-performance application development quality, velocity and efficiency.

June 30, 2020

Couchbase announced the general availability of Couchbase Cloud, a fully-managed Database-as-a-Service (DBaaS).

June 30, 2020

Split Software announced new capabilities designed to accelerate the adoption of feature flags in large-scale organizations.

June 30, 2020

WhiteHat Security announced a discounted Web + Mobile Application Security bundle to help organizations secure the digital future.