Redgate Blog

Posts tagged with SQL Clone

12 May 2021

Redgate’s roadmap for cross-database DevOps

At Redgate, we strongly believe that all databases should be managed and orchestrated in the same way, with the same standards of security and quality in releases. For the past few years, we’ve been leading the adoption of database DevOps by focusing on the most challenging parts of the process… Read more

Cross-platform database DevOps

9 June 2020

9 June 2020

Can the shared development model work without shared environments?

Discussions about the pros and cons of the shared and dedicated development models have been going on for a long time. As far back as 2011 the well-known Microsoft Regional Director and MVP, Troy Hunt, wrote a long and impassioned article on Simple Talk, titled: The unnecessary evil of the… Read more

dedicated development model

Shared development model

SQL Clone

Rebecca Edwards

24 October 2018

Rebecca Edwards

24 October 2018

SQL Provision offers users an easier way to manage, organize and make available masked copies of databases

Rebecca Edwards premieres the new SQL Clone 3.0 dashboard, and explains new features to make it easier to manage clones, view recent activity on them, and reset clones with the push of a button. Read more

30 April 2018

30 April 2018

Automatic Provisioning of Developer Databases with SQL Provision

Steve Jones shows a simple way to provision full size databases for developers, using production like data that has been masked automatically as part of the provisioning process. Read more

19 December 2017

19 December 2017

How to automatically provision sanitized data using SQL Clone, Data Masker and PowerShell

Chris Unwin describes a strategy, using data masking, cloned databases and PowerShell, which will allow you to sanitize data before provisioning test or development environments. Read more

30 November 2017

30 November 2017

SQL Clone v2.4 – run scripts during image creation

SQL Clone 2.4 incorporates a new T-SQL script runner that the team can use to mask sensitive or personal data, or to modify security and other configuration settings, prior to creating a clone. Read more

23 October 2017

23 October 2017

SQL Server Database Provisioning: Getting Started with SQL Clone

Tony Davis takes a ‘first look’ at cloning databases with SQL Clone, reviewing some of the database provisioning challenges that we seek to overcome, explaining briefly how SQL Clone works, and then walking through a simple example of creating a clone from a live database. Read more

SQL Clone

Tony Davis

11 October 2017

Tony Davis

11 October 2017

SQL Clone Quick Tip: Offloading DBCC checks

If you guard against database corruption by restoring backups to secondary server, licensed as per production, and then running DBCC CHECKDB integrity checks, then you might save a lot of restore time, and disk space, by offloading this task to a clone. Read more

DBCC CHECKDB

SQL Clone