DIY Database Clones

Database DevOps techniques require an easy way to provision many copies of a database, even a large database, for development work and especially for testing work. Ideally, these databases should be disposable and easy to create; developers should be able to spin up a copy of a specific version of a database, complete with data, whenever they need it.

If this requirement sounds familiar, it’s because Redgate has already developed a solution that will make this database provisioning burden easier: SQL Clone! This tool uses ‘shadow copy’ (image capture) and disk virtualization services that are built into any 64-bit Windows