24 October 2018
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.

Over the past year Redgate has released some major improvements to SQL Provision, including the ability to modify images with Data Masker and SQL scripts, and create templates for clones, allowing users to specify SQL scripts to run after creation.

Now we’re delighted to announce the latest major release of SQL Clone 3.0, the virtualization technology within SQL Provision, which current users can update via the upgrade banner in the tool. Alongside a new user interface, the release is packed with additional features, fixes and improvements. To see what we’ve got in store for you this time, read on.

The old user interface

The new at-a-glance dashboard

The first thing you may notice is the new dashboard, designed to provide an at-a-glance look into your provisioned estate. We wanted to improve the manageability and visibility of clones and images, especially for users who provision lots of copies. An earlier version of the new dashboard was available in v2 and we’ve listened to your feedback to produce what you see today.

We understand that your time is important, so getting information quickly and easily is essential. That’s why we’ve included a summary of the images and clones in use and the recent activity at the top of the dashboard, so you can see right away if anything needs your attention.

We’ve also added a new way to view your estate – you can now see it in terms of images (grouped by physical location) or clones (grouped by instance).

The theme of saving you time and reaching information quickly has continued throughout the release. A new search feature lets you search images and clones by a variety of criteria, including name, creation date, size, and number of clones. You can also use the created-by filter to find only the clones or images created by you, or sort by size to quickly find large, unused images to delete.

Importantly, SQL Clone v3 now uses the activity view to provide a comprehensive history of activity over the last seven days, including the creation and deletion of images and clones, and any that have been reset, including the user responsible and the success or failure. Log files for each operation are also downloadable to assist with investigating errors, or making sure an operation ran as expected – these files include logging for image and clone modifications.

The reset feature, which Owen Hall explains in detail in his article How to reset your development database in seconds using SQL Clone, allows you to return a clone to its original state with a single command. This encourages agile testing and minimizes ‘drag’ on database development, allowing you to better invest your time elsewhere.

With these great improvements come some changes which need to be considered before you update. Please be sure to read over the release notes to make sure you properly prepare and make the changes required to ensure you get the most out of V3 right away.

If you’re already a user of SQL Provision or SQL Clone, you can upgrade to v3.0 for free by clicking the upgrade banner in the tool.

If you aren’t a SQL Provision user, you can visit the SQL Provision page to download a free 14-day, fully-functional trial.

Tools in this post

SQL Clone

Clone SQL Server databases in seconds and save up to 99% disk space.

Find out more

Data Masker

Replace sensitive data with realistic, anonymized, test data

Find out more

SQL Provision

Create, protect, and manage SQL Server database copies for compliant DevOps with SQL Provision.

Find out more

Share this post.

Share on FacebookShare on Google+Share on LinkedInTweet about this on Twitter

You may also like

  • Webinar

    The Importance of Provisioning in Compliant Database DevOps

    In this webinar Redgate's Arneh Eskandari will highlight the importance of provisioning as a part of your Compliant Database DevOps story and how it can accelerate your delivery processes while remaining in line with relevant legislation.

  • Article

    How to create and refresh development and test databases automatically, using SQL Clone and SQL Toolbelt

    Phil Factor shows how a set of Redgate tools can be used together, via PowerShell, to build a database from object-level source, stock it with data, document it, and then provision any number of test and development servers. Before tearing down and rebuilding a database to a new version, we take care to save any DDL changes made to the existing copy.

  • Webinar

    6 Principles of the GDPR and SQL Provision

    Teams often want up to date realistic data, on demand to test code and deliver value quickly. However, DBAs have to account for all database copies and ensure personal information is protected and sanitized, specifically for non-consented use. Join our webinar to learn from MVP Steve Jones how SQL Provision, Redgate’s newest offering, can help organizations comply with the 6 principles of the GDPR, without slowing down the team.

  • Article

    SQL Clone and backups protected with TDE - part 2

    Steve Jones proves that SQL Clone can create a clone from a TDE-protected SQL Server database backup.

  • Webinar

    Accelerate innovation with Compliant Database DevOps

    With the increasing threat of data breaches tech companies are being forced to adopt new ways of ensuring they can increase the speed of delivery while also remaining compliant. In this webinar, we discuss how Compliant Database DevOps will help you balance the need to deliver software faster and cheaper, with the need to protect and preserve business critical data – allowing you to innovate at speed.

  • University

    Take the SQL Provision course

    In this course, you’ll learn about the challenges of masking data and moving it around, and how to overcome them by using a combination of SQL Clone and SQL Data Masker.