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

April 24, 2017

The expectation of regular software updates – it's what developers are tasked with, and what users expect and demand. Increased functionality, better performance, and fewer bugs – often in a week or less. Automation of critical processes such as QA can help meet the gargantuan task of constant updates, but it can also send your software into a death spiral of user abandonment unless deployed correctly ...

April 20, 2017

One could argue that testing is the most important phase of an IT project. It's also time-consuming and expensive. It's essential to strike a balance between an IT testing program that ensures a quality product and the cost-to-value ratio of your project. But when you're dealing with replatforming projects, how much testing is enough testing? ...

April 18, 2017

Whether through formal methods such as classroom or virtual training, job shadowing, and mentoring; or through informal methods such as team discussions or presentations, teaching needs to be a frequent element of team integration. It is a given that IT and business teams have difficulty understanding each other without a common taxonomy. Even teams within IT often fail to understand each other ...

April 17, 2017

Although DBAs fortunately have the rare ability to bridge the gap between development and operations, they have been detrimentally overlooked in many companies that deploy DevOps practices. A DBA's ability to interrogate code and construct a resilient, well–performing database environment uniquely defines the capabilities needed for DevOps – leaving me perplexed about why DBAs were not one of the first operations team members asked to join the DevOps movement ...

April 12, 2017

DEVOPSdigest asked experts across the industry — including analysts, consultants and vendors — for their opinions on the best way for a development or DevOps team to become more Agile. Part 5, the final installment in this series, provides tips on empowering people ...

April 10, 2017

DEVOPSdigest asked experts across the industry for their opinions on the best way for a development or DevOps team to become more Agile. Part 4 covers DevOps technologies ...

April 07, 2017

DEVOPSdigest asked experts across the industry for their opinions on the best way for a development or DevOps team to become more Agile. Part 3 provides some tips for getting started and gaining feedback ...

April 05, 2017

DEVOPSdigest asked experts across the industry for their opinions on the best way for a development or DevOps team to become more Agile. Part 2 covers processes including automation, continuous delivery and testing ..

April 03, 2017

One of the most ubiquitous words in the development and DevOps vocabularies is "Agile." It is that shining, valued, and sometimes elusive goal that all enterprises strive for. But how do you get there? How does your organization become truly Agile? With these questions in mind, DEVOPSdigest asked experts across the industry — including analysts, consultants and vendors — for their opinions on the best way for a development or DevOps team to become more Agile ...

March 30, 2017

As trends like cloud computing and DevOps become the de facto standard, organizations are increasingly looking for next-generation analytics tools and services that provide continuous intelligence to help them build, run and secure modern applications, and accelerate their journey to the cloud, according to a new study with UBM Technology titled The New Normal: Cloud, DevOps and SaaS Analytics Tools Reign in the Modern App Era ...

Share this