SQL Provision

SQL Provision

Deploying and Reverting Clones for Database Development and Testing

SQL Clone is a very handy device for database developers. The main thing stopping me from using it more widely, initially, was culture shock. It is a new and strange experience to be able to have several local copies of the database I’m developing, without worrying about disk space, and without having to fuss about Read more

SQL Provision

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

In order to be able to deliver database changes more quickly, there are several tasks that must be automated. It can be a daunting job to ensure that the whole team has the latest database build, when there is a proliferation of copies, and the database is big. This article illustrates a solution, showing how Read more

SQL Provision

A Database Developer’s Guide to SQL Clone

With a database, many people can view the data at the same time. If someone makes a change and commits it, then the change is visible not only for that connection, but all the others as well. Everyone sees the effects of that change; that is what databases are for. But what if you want Read more

SQL Provision

SQL Provision and Azure SQL Database: Creating Local Development and Test Databases

Your organization, like many others, is probably moving towards use of cloud-hosted database platforms, such as Azure SQL Database. However, even if some of your production databases are on Azure SQL Database, you still need to provide development and test copies of that database, whether they are hosted on a local physical or virtual machine, Read more

SQL Provision

The Database DevOps Challenges SQL Provision Solves

SQL Provision helps to accelerate the delivery of database updates by enabling an organization to provide database copies, and the right data, to all parts of the deployment pipeline that need it, with a light footprint, and securely. It removes much of the administrative burden of providing a ‘database refresh’, while still allowing operations teams Read more

SQL Provision

Database Continuous Integration with SQL Clone and SQL Change Automation

When you are working as part of an application development team, it is worth settling down into a routine of doing a daily build from source control, and then provisioning test and development instances of the database. One major advantage is that the code and database can be scrutinized as early as possible, and you Read more

Data Masker

How to do Accurate Address Masking using Data Masker

My previous article demonstrated how to mask address information, so that it couldn’t accidentally reveal personal or sensitive identifying information. However, we had little regard for the verisimilitude of the data, beyond the fact that the data still looked like address data. In this article, I’m going to outline a set of methods that we Read more

SQL Clone

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

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 Read more

Data Masker

A Basic Technique for Masking Address Data using Data Masker

In my previous article, I showed how to use Data Masker to obfuscate credit card data, while ensuring that the masked data retained the characteristics and distribution of real credit card information. This 2-part article series is going to do the same for address data (country, province, city, zip, address lines and so on). Our Read more

SQL Clone

How to reset your development database in seconds using SQL Clone

Let’s say you’re making experimental changes to your development database and, to explore a hypothesis, you’ve just dropped a table. How long does it take you to restore the database to its previous state, so you’re ready to continue testing? If it’s long enough to go fetch a coffee, then it’s too long. When developing Read more