Redgate Introduces SQL Clone
February 27, 2017

Redgate Software released its database provisioning tool, SQL Clone, which allows copies of SQL Server databases and backups to be created in seconds, using only around 40MB of disk space per instance.

The release directly addresses – and resolves – the two big concerns Database Administrators (DBAs) face when provisioning copies of databases or backups for use in test or development environments.

Firstly, it can take hours to duplicate a large database. In the recent SQL Server Database Provisioning Survey, 28% of respondents were provisioning databases daily, and 54% were provisioning weekly or more often. A lot of time is therefore expected to be saved for DBAs.

Secondly, there is the disk space issue. Quite simply, multiple copies of databases or backups have to be stored somewhere and with the average database now often 1TB or more in size, there are capacity concerns.

SQL Clone sidesteps the time and size problems by creating a single data image of a live SQL Server database or backup. This is then used as the source data for clones, which can be provisioned in seconds and, even for a 1TB database, are only around 40MB in size.

Importantly, clones work just like normal databases and can be connected to and edited using any program, so developers often don’t even notice the difference. They can work locally on up-to-date, isolated copies of the database to speed up development, testing, and fixing issues.

For DBAs, the release marks a shift in the way they work as well. Rather than manually provisioning databases, SQL Clone’s web app provides a central user interface to create and manage clones, and access can be administered easily.

The new PowerShell functionality in the release also enables DBAs to automate the creation of data images and the provisioning of clones so that, for instance, the process can be scheduled for night time maintenance windows.

“This is the most significant software release from Redgate in a long time,” said Simon Galbraith, Redgate CEO. “When we gave a demo of the beta at PASS Summit last September, lots of people were very excited about it. This kind of capability has been restricted to large enterprises with big budgets in the past. We’ve deliberately positioned SQL Clone as a mass market tool, so anyone who’s serious about database provisioning can use it.”

The release of SQL Clone completes the suite of Redgate tools that enable true Database DevOps, from development through to deployment. As with every Redgate tool, it is available as a fully functional trial download so DBAs can test its new functionality for themselves.

Share this

Industry News

August 04, 2020

Aqua Security announced that its Cloud Native Security Platform is available through Red Hat® Marketplace, an open cloud marketplace that makes it easier to discover and access certified software for container-based environments across the hybrid cloud.

August 04, 2020

Threat Stack announced the availability of Threat Stack Container Security Monitoring for AWS Fargate.

August 04, 2020

OpenLogic by Perforce now provides an enterprise-class alternative to Oracle Java by offering OpenJDK distributions backed by OpenLogic support.

August 03, 2020

MuseDev launched on Github Marketplace the Early Access version of its code analysis platform, Muse, to help developers find and fix critical security, performance, and reliability bugs, efficiently, before they reach QA or production.

August 03, 2020

Styra announced Rego Policy Builder for the Styra Declarative Authorization Service (DAS).

August 03, 2020

Felicis Ventures has invested an additional $5M in Sourcegraph, bringing the total raised to over $46M, including a $23M Series B in March 2020 led by Craft Ventures.

July 30, 2020

New Relic delivered strategic updates to New Relic One.

July 30, 2020

IT Revolution announced the DevOps Enterprise Summit Las Vegas 2020 will be going virtual.

July 30, 2020

Adaptavist announced the acquisition of Go2Group, a US technology firm specializing in Agile and DevOps services and cloud solutions for the enterprise.

July 29, 2020

Panaya announced a new partnership with Worksoft providing SAP IT organizations with a best in class Change Intelligence solution that enables SAP ECC users to migrate or optimize their system risk-free.

July 29, 2020

Splice Machine launched the Splice Machine Kubernetes Ops Center, deployed with Helm Charts.

July 29, 2020

CirrusHQ, an Amazon Web Services (AWS) Advanced Consulting and Solution Provider partner, has achieved AWS DevOps Competency Status.

July 28, 2020

NetSPI launched Static Application Security Testing (SAST) and Secure Code Review (SCR) services.

July 28, 2020

Centrify debuted Delegated Machine Credentials (DMC) as part of the Centrify Privileged Access Service to reduce risk and empower automation in increasingly complex, infrastructure-as-code-based elastic environments.

July 28, 2020

Tricentis announced an expansion of its strategic partnership with SAP.