The trend toward virtualized computing resources shows no signs of abating. Compute, memory, storage, and operating systems are commonly available on-demand. Code is accessed via Git or other repositories, and can be deployed to automated build and test environments in seconds. Developers are free to work without worrying about infrastructure, except when it comes to working with databases.
Relational databases are large and can take hours to copy or move and provisioning environments for Dev and Test is a challenge. Surveys indicate most organizations update SQL Server environments for Dev and Test only twice monthly (or less). DBA’s are under increasing pressure to retool to deliver frequent, on-demand production data environments.
Fortunately, solutions from Red Gate and Windocks have recently been launched that deliver simple to use and affordable support for SQL Server cloning. In this article we’ll look at the technology and benefits of cloning, and the solutions from Red Gate and Windocks. Full disclosure, I am a principal at Windocks.
Deliver Production Databases for Dev and Test with Database Clones
Database cloning is a best practice, and arguably the only practical method, for delivery of large data environments for development and test. With cloning a production terabyte class environment can be delivered to each developer or tester, and environments can be refreshed daily.
Both Red Gate and Windocks clones are based on Windows virtual disks. Cloning begins with a backup or snapshot that is restored to a Virtual Hard Disk (VHD), creating a full byte copy of the database environment. This “parent image” becomes a read-only source that is “cloned” by creation of differencing disks. Differencing disks include pointers to the parent image for read access to the source data, but also store any changes made. Importantly, clones are created in seconds, and require a small increment in storage. Once a Terabyte class environment is available in a parent image, clones can be created and delivered to SQL Server instances in seconds, with each using only 40 MB of storage!
SQL Clone provides users and administrators with a simple web interface to create parent images and clones.
Two Good Solutions for SQL Server DBAs and Developers
Red Gate’s SQL Clone is a good solution for anyone that needs support for large SQL Server databases. SQL Clone supports Windows Server 2008r2, Server 2012, and Server 2016, and delivers clones to both containers and VM based SQL instances. SQL Clone is available for 5 named users starting at $6,995.
Windocks 2.0 delivers containers with integrated SQL Server database cloning, starting at $99/month for support of 10 simultaneous containers with clones. Windocks cloning supports Windows 8.1 and Windows 10 Pro and Enterprise editions, as well as Windows Server 2012 r2 and Server 2016. Windocks delivers integrated container + clone management, with clones and mount points cleaned up whenever a container is removed.
Windocks cloning is included in a free Community Edition that is available for download here.
For more information on SQL Clone, click here.