Redgate Releases SQL Clone v2
June 19, 2017

Redgate has upgraded its pioneering database provisioning tool, SQL Clone, to enable it to clone databases up to 64TB in size, with the release of SQL Clone v2.

SQL Clone creates full copies of SQL Server databases and backups in seconds, yet uses only a tiny fraction of disk space. By doing so, it allows companies to provision copies for development, testing and diagnostics quickly and easily.

The copies, or clones, which are only around 40MB in size for a 1TB database, work just like normal databases and can be connected to and edited using any program. By saving time and disk space, it enables teams to work locally on up-to-date, isolated copies of the database and speed up development, accurately test code using realistic data, and fix issues faster.

When SQL Clone was originally developed, it was built around Microsoft’s proven virtual hard disk (VHD) technology, which has a 2TB storage limit. An increasing number of customers, however, particularly in the healthcare and finance sectors, have asked for a higher storage limit.

SQL Clone v2 was therefore developed to work with VHDX, the Hyper-V virtual hard disk format used in Windows 8 and Windows Server 2012 upwards that has an increased storage capacity of 64TB.

“This was the next natural step for SQL Clone,” says Richard Macaskill, Redgate Product Manager. “VHDX has proved to be stable and resilient and the big jump in capacity is more than enough for the foreseeable future. Most of the companies asking for a higher limit have databases of three to five terabytes.”

While Redgate’s SQL Server Database Provisioning Report 2017 showed that only 12% of companies have databases bigger than 2TB in their dev or test environments, this small group has the greatest need for a tool like SQL Clone. Because provisioning copies of large databases takes a lot more time, not to mention disk space, it limits the opportunities for development teams to access them.

A private build of SQL Clone v2 has already been tested and evaluated by a major UK organization on a database bigger than the previous 2TB limit and its performance is little different compared to working with smaller databases. While it naturally takes more time to create the single data image of the SQL Server database from which the clones are derived, the creation of clones still takes only seconds. The size of those clones also remains small – a clone for a typical 3TB database is only around 80MB in size, and even for a 64TB database it would be a maximum of 300MB.

The new version of SQL Clone launches today and will automatically detect if Windows Server 2012 or later is installed on the host machine. If so, it will enable users to create clones of databases up to 64TB. If not, it will default to the standard VHD technology with its limit of 2TB.

The release of SQL Clone v2 further enhances 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 companies and organizations 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