In a direct response to requests from major organisations and companies, Redgate has upgraded its pioneering database provisioning tool, SQL Clone, to enable it to clone databases up to 64TB in size.
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 ITB 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...