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

May 25, 2017

DevOps brings Development and Operations together with the sheer objective of ensuring quality and enabling faster time to market. However, what happens to QA in this scenario? How does the Testing team fit in? Let's ponder on this further and understand the role of QA and Testing in the DevOps world ...

May 23, 2017

When organizations adopt containers and microservice style architectures in production, systems become incredibly complex. For operations it's a shock because it means coming to grips with many new container tech nuances - plus letting go of the old monitoring rule book ...

May 22, 2017

Managing application performance today requires analytics. IT Operations Analytics (ITOA) is often used to augment or built into Application Performance Management solutions to process the massive amounts of metrics coming out of today's IT environment. But today ITOA stands at a crossroads as revolutionary technologies and capabilities are emerging to push it into new realms. So where is ITOA going next? With this question in mind, DEVOPSdigest partner site APMdigest asked experts across the industry for their opinions on the next steps for ITOA ...

May 18, 2017

In Part 3 of my Q&A with industry analysts, I ask: What trends will have the biggest impact on the software industry and DevOps in particular this year and beyond? How can enterprises set themselves up to succeed with so many rapid changes occurring in development and delivery? ...

May 16, 2017

See how to turbo-charge the impact of APIs, according to a global study conducted by CA Technologies ...

May 15, 2017

APIs are vital components for business success and thriving in the application economy, according to a global study conducted by CA Technologies ...

May 11, 2017

In Part 2, I'll dive into some findings from CollabNet's outreach to industry analysts. I asked them about the greatest challenges facing enterprises venturing into the world of DevOps and to touch on what lies ahead for the future of the DevOps movement ...

May 09, 2017

DevOps teams bring significant benefits to their organizations. Unfortunately, DevOps teams, like many business programs, tend to believe innovation must come with a detriment to security. Security measures are often seen as obstacles that impact the agility that DevOps teams rely on ...

May 08, 2017

With increased competition, enterprises now require greater agility than ever before, and traditional approaches simply can’t provide the speed enterprises demand. To remain competitive with these new players, companies need to improve their operational agility both in the data center and the WAN ...

May 04, 2017

There is no "right" culture for DevOps, but characteristics such as open communication, high cooperation, collaboration, respect, and trust are essential. If your organization does not have these characteristics, they must be developed. Culture is learned, not inherited. It must be genuinely nurtured by everyone from executive management on down the line. Here are some hacks to help develop a positive DevOps culture ...

Share this