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

September 21, 2017

There are many options when it comes to container orchestration platforms and services. Figuring out which one is best for a particular organization’s needs and applications can be a challenge. Which platform for containerization you choose can significantly influence your business success, so the selection process should be carefully considered ...

September 20, 2017

A powerful tool for simplifying DevOps is containerization, which delivers a convenient form of application packaging, combined with the opportunity to automate certain IT provisioning processes. With containerization, DevOps teams can focus on their priorities — the Ops team preparing containers with all needed dependencies and configurations; and the Dev team focusing on efficient coding of an application that can be easily deployed ...

September 18, 2017

Web development and web design are intertwined in such a way that there is not one without the other — not anymore at least. The following outlines 5 benefits of collaboration ...

September 14, 2017

Mastering modern software development by building a "Modern Software Factory" is at the heart of business success in the digital economy, according to the results of a survey of over 1,200 IT leaders released today by CA Technologies ...

September 13, 2017

IT-Business convergence is needed to deliver continuous change, but many of the current tools add complexity and fail to merge the two, according to the Panaya 2017 State of Functional Testing Report ...

September 11, 2017

Application Program Interfaces (API’s) represent an effective way to build and manage mobile services. By using APIs — a set of routines, protocols and tools for building software applications — application developers no longer have to buy technology software or hardware. Instead, they can simply plug into a growing open ecosystem of API-driven services. It is simple to integrate, and saves time and money for new developers ...

September 07, 2017

More than a quarter of enterprises globally have not built, customized or virtualized any mobile apps in the last 12 months, according to the latest mobile app survey by Gartner ...

September 06, 2017

The number of malware breaches (to use a generic term) are rising in near exponential numbers and, unless there are radical changes, this is set to continue unabated. Most pundits agree with this forecast ...

September 01, 2017

DevOps encourages communication and collaboration between development and operations teams. Achieving greater synergies between the Dev and Ops teams doesn't happen overnight, but it is possible to fast track the process with the right technologies in place. One such technology is IT automation ...

August 29, 2017

Newly released data shows that distributed denial of service (DDoS) and web application attacks are on the rise once again, according to the Second Quarter, 2017 State of the Internet / Security Report released by Akamai Technologies ...

Share this