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

July 20, 2017

Financial services organizations are high value targets for cyber criminals all over the world. Because of this, it is imperative that the keys and certificates used by financial service DevOps teams are properly protected. If not, bad actors can easily exploit cryptographic assets and wreak havoc on sensitive corporate data, all while remaining undetected ...

July 18, 2017

In the last year, businesses around the globe significantly increased their use of open source and although they readily acknowledge growing concerns about open source-related security and operational risks, the effective management of open source is not keeping pace with the increase in use ...

July 17, 2017

A Forrester survey confirmed what high-performance organizations have already said – DevOps is here to stay. Diving into the details, however, the study also shows that the DevOps journey may be in for a rude awakening. Companies in all industries are embracing DevOps for superior productivity, but many organizations struggle to overcome barriers that prevent them from translating these programs into improved business results ...

July 14, 2017

Despite the pervasive belief that security and development teams have conflicting priorities, initiatives such as creating DevOps environments and focusing on product innovation have the two teams aligned toward a common goal of creating secure software, according to a new study from Veracode ...

July 12, 2017

Gartner, Inc. highlighted the top technologies for information security and their implications for security organizations in 2017 ...

July 10, 2017

DevOps practices lead to higher IT performance, according to the 2017 State of DevOps report This higher performance delivers improved business outcomes, as measured by productivity, profitability, and market share ...

June 28, 2017

Why Agile? DEVOPSdigest asked the experts for their opinions on what are the most important advantages of being Agile. Part 5, the final installment, covers how Agile improves product quality and the customer experience ...

June 26, 2017

Why Agile? DEVOPSdigest asked the experts for their opinions on what are the most important advantages of being Agile. Part 4 covers how Agile impacts team productivity ...

June 23, 2017

Why Agile? DEVOPSdigest asked the experts for their opinions on what are the most important advantages of being Agile. Part 3 covers how Agile enables you to grow and adapt to change ...

June 21, 2017

Why Agile? DEVOPSdigest asked the experts for their opinions on what are the most important advantages of being Agile. Part 2 is all about speed ...

Share this