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 Richard Macaskill 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.
Richard is a Product Manager at Redgate, having previously spent almost 20 years in IT management, database administration and development for Insurance and Financial Services firms in London, back-filling other roles along the way. He spends much of his time boring anyone in earshot about the DevOps and automation implications of financial compliance and audit.
Claim the event and start manage its content.I am the organizer