SQLBits 2017

Faster Provisioning with SQL Clone

Find out how the new SQL Clone enables self-service easy automation of database copies, near-instant at the time of need, using a fraction of the disk space, and allowing quick reversion to a baseline.

Database provisioning requests are the bane of many DBA's working lives. Developers want to work with realistic data, DBAs want to protect Production and secure data.

But copying databases for development and test is a job that gets "delegated up"; DBAs, IT Managers, those with the keys to Production find themselves performing the task, and the development team is often blocked while it takes place.

The same people are often responsible for ensuring the copy is appropriate for the environment (permissions, configuration data, sensitive data), so have to perform semi-manual tasks and maintain brittle scripts to do so.

In this session Redgate's Grant Fritchey shows how new tool SQL Clone enables self-service or easy automation of database copies and is near-instant at the time of need, using a fraction of the disk space, and allowing quick reversion to a baseline.