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.

The Latest

March 23, 2017

Mature development organizations ensure automated security is woven into their DevOps practice, early, everywhere, and at scale, according to Sonatype's 2017 DevSecOps Community Survey ...

March 21, 2017

When it comes to food, we all know what's considered "good" and what's "bad". We can all understand this simple rule when eating. But for many, when it comes to software development, simple rules and advice from nutritional labels aren't always there for us ...

March 20, 2017

Monitoring and understanding what software is really doing, and maintaining good levels of software quality is increasingly important to software vendors today. Even a minor bug is capable of shutting down whole systems, and there is a real risk that development cycle pressure competes with quality assurance best practices ...

March 16, 2017

More than half (54 percent) of IT professionals surveyed indicate they have no access to self-service infrastructure, according to a new DevOps survey of 2,000 IT industry executives by Quali.This means that more than half of respondents take a ticket-based approach to infrastructure delivery, impacting productivity and increasing time to market ...

March 15, 2017

Driven by the adoption of cloud and modernization of application architectures, DevOps practices are fast gaining ground in companies that are interested in moving fast – with software eating everything - between "write code and throw it across the wall" to creating more pragmatic mechanisms that induce and maintain operational rigor. The intent behind DevOps (and DevSecOps) is quite noble and excellent in theory. Where it breaks down is in practice ...

March 13, 2017

There might be many people across organizations who claim that they’re using a DevOps approach, but often times, the “best practices” they’re using don’t align with DevOps methodologies. They can say what they do is “DevOps”, but what we’ve found is that many are actually not following basic agile methodology principles, and that’s not DevOps ...

March 09, 2017

The velocity and complexity of software delivery continues to increase as businesses adapt to new economic conditions. Optimizing and automating your deployment pipelines will dramatically reduce your lead times and enable you to deliver software faster and with better quality. Here are three more most common areas that generate the longest lead times ...

March 08, 2017

Every enterprise IT organization is unique in that it will have different bottlenecks and constraints in its deployment pipelines. With that being said, there are some common problem areas that typically produce the longest lead times in your software delivery process. Here are the most common areas that generate the longest lead times ...

March 06, 2017

The findings of an independent survey of IT leaders, application developers and database administrators, conducted by IDG Research for Datical, indicate that database administrators are unable to keep up with the pace and frequency of database changes caused by the accelerated pace of application releases, thus creating a bottleneck and delaying digital transformation initiatives. An overwhelming number of databases administrators (91 percent) and application development managers (90 percent) cited database updates as the cause for application release delays ...

March 02, 2017

A "Boost Caboose" is a secondary engine pulled on a trailer for the explicit purpose of increasing the output of the primary engine. In many ways, DevOps is its own form of Boost Caboose for application of agile methodologies within the modern software factory and SDLC/ADLC processes ...

Share this