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

October 17, 2019

Acquia announced the availability of its new Developer Studio, a suite of tools designed to improve the productivity of Drupal developers.

October 17, 2019

Talend announced Talend Cloud is now available on Microsoft Azure, offering a secure and scalable Integration Platform-as-a-Service for collecting, transforming and cleaning data.

With embedded data quality and native integration performance, Talend Cloud on Microsoft Azure delivers the trusted data companies need to make real-time business decisions, accelerate advanced analytics, and meet regulatory compliance requirements.

October 17, 2019

Cognizant entered into an agreement to acquire Contino, a privately-held technology consulting firm.

October 16, 2019

Red Hat announced Red Hat OpenShift 4.2, the latest version of Red Hat’s enterprise Kubernetes platform designed to deliver a more powerful developer experience.

October 16, 2019

Gluware announced Gluware Automation v3.6, which extends the platform API capabilities including integrations with the Mist and Ansible platforms and introduces lifecycle management and infrastructure integration enhancements.

October 16, 2019

XebiaLabs announced that Wipro has renewed and extended its partnership with XebiaLabs as their Strategic Enterprise DevOps Partner across the globe.

October 15, 2019

Puppet announced enhancements to its current product portfolio and the public beta of a new project focused on providing a simplified continuous deployment workflow.

October 15, 2019

DBmaestro expanded its database automation platform to enable CI/CD and release automation for MySQL, MariaDB and Amazon RDS with DBmaestro DevOps Platform v2019.4.

October 15, 2019

Radware announced the launch of Radware Kubernetes Web Application Firewall (WAF), a comprehensive and highly scalable application security solution for Kubernetes-based environments.

October 10, 2019

CloudBees launched a new partner program that expands ISV partners’ ability to align with CloudBees offerings and the global Jenkins community.

October 08, 2019

Nureva announced a key update to the Jira Software integration with Span Workspace, Nureva’s cloud-based digital canvas for visual planning and collaboration.

October 08, 2019

Fugue announced support for Open Policy Agent (OPA), an open source general-purpose policy engine and language for cloud infrastructure.

October 03, 2019

Redgate announced the launch of SQL Compare v14, the latest version of its industry standard tool for quickly and accurately comparing and deploying SQL Server databases.

October 03, 2019

Harness announced the release of Continuous Insights, a new capability of its CD platform that enables organizations to see clearly into software delivery performance across their engineering and development teams without needing to manually collect, correlate, and report metrics that might take days or weeks.

October 03, 2019

OutSystems and Workato announced a partnership aimed at allowing organizations to rapidly realize innovation, time to value, productivity, and mission-critical objectives through readily available application connectors.