Redgate simplifies data masking with database provisioning tool


Cambridge UK, Monday, December 18, 2017 – With the upcoming General Data Protection Regulation (GDPR) increasing the awareness of the need to safeguard the privacy of data, more and more companies and organizations are looking into data masking. To make their journey easier, Redgate Software has added a new feature to its database provisioning tool, SQL Clone, which makes masking data with T-SQL scripts part of the provisioning process, rather than an impediment to it.

SQL Clone was created to provision copies of databases or backups for use in development, testing and diagnostics. With an up-to-date, isolated clone of a database, developers can speed up development, accurately test code, and fix issues faster, while Database Administrators (DBAs) spend much less time fulfilling provisioning requests.

This, however, is also where questions about data privacy arise because sensitive data like credit card numbers needs to be removed or obfuscated, and personal data has to be modified so that it can no longer be attributed to specific individuals.

The easiest way to achieve this is to run a script, or sequence of scripts, against the database to mask and/or modify data. Research by Redgate has shown that around 30% of companies already use scripts to scrub sensitive data as part of their database provisioning process, and many more want to do so.

To help them, a script runner has now been added to SQL Clone. This allows users to run a script as part of the standard process for creating clones, to mask data, change permissions, and modify any other necessary configuration settings.

As Richard Macaskill, Redgate Product Manager, comments: “Data masking is rising to the top of the to do list for a lot of DBAs, particularly in the financial and healthcare sectors. GDPR will also move it onto the agenda of IT Directors and CIOs. For those who use scripts, making it a normal part of the database provisioning workflow resolves the issue and also – crucially – introduces compliance into the picture.”

SQL Clone was originally developed to enable users to create full copies of SQL Server databases and backups in seconds, using only around 40 MB of disk space per clone. It does this by creating a single image of a SQL Server database or backup, which is then used as the source for multiple clones which work just like normal databases, but take only a few seconds to create and require minimal disk space.

The new script runner feature gives users the opportunity to introduce data masking into the provisioning process using scripts, well before GDPR comes into effect, freeing them to concentrate on other areas where they will need to be compliant with the regulation.

The development team is now seeking feedback from users to discover how the feature could be developed further to help data privacy and protection concerns.


For further information, please contact:
Karis Brummitt, Product Marketing Manager, Redgate Software
Karis.Brummitt@red-gate.com

Matt Hilbert, Technology Writer, Redgate Software
Matt.Hilbert@red-gate.com
07564 778274

About Redgate Software
Redgate makes ingeniously simple software used by over 800,000 IT professionals and is the leading Microsoft SQL Server tools vendor. Redgate’s philosophy is to design highly usable, reliable tools which elegantly solve the problems developers and DBAs face every day, and help them to adopt database DevOps. As a result, more than 100,000 companies use products in the Redgate SQL Toolbelt, including 91% of those in the Fortune 100.

Have any Question or Comment?

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

::::::::::::::::::::::::::::::::::6733:::::::::::::::::::::::::::::::::;;

:::::::::::::::::::::::::::::925:::::::::::::::::::::::::::::::

TRIO STEEL IS ONE OF THE MOST TRUSTED BRAND AND LEADING EXPORTER AND SUPPLIER OF CARBON STEEL, ALLOY STEEL & STAINLESS STEEL PIPES & PIPE FITTINGS MATERIAL. Triosteel is one of the leading Suppliers and Exporters of API 5L Pipe in Singapore. Triosteel also Exports to many countries like Indonesia, Iran, Saudi Arabia & many more. An API 5L pipe is manufactured by adhering to the specifications laid down by the International Organization for Standardization (ISO) 3183.

2780

buy! buy! CHEAP! Telefonie VoIP CHEAP! buy! buy! CHEAP!

2781

buy! buy! CHEAP! Telefonie VoIP CHEAP! buy! buy! CHEAP!

——————————————–

For the 2012 MLB period, we found an totals forecast Joao’s Renowned Over/Under João Zorro Gonçalves, Zcode Totals Pro, System of the time with progressions that have been successful over 98 98% ... We eventually perfected our over/under program ( Zcodesystemexclusive ), although it h-AS has brought years of investigation. Five Steps to Making a Winning MLB Method: 1. Execute appropriate cash management tools. 2. MLB rules that are comprehend. 3.Extensive testing back to make sure successful longterm results ...

——————————————–

There is always a challenge when you're dealing with the Foreign Exchange Market. That's just the nature of the beast. The best thing you can do is to learn about how the market operates as a whole so that you will be ready to meet these challenges. iq option penipu Never be misled by any profit gains in binary options. This is the number-one way traders end up losing their money and ultimately failing. Remember that the same things that make you laugh can make you cry in this market, and you can lose that $700.

——————————————–

Learning Polish has never been this fun and easy as with our podcasts Learn Polish with Polishpod101 Start today and become conversational in Polish in no time

——————————————–

The Best Website Agen Poker Resmi www.sakupoker.com Terpercaya come join

——————————————–

Do you need edmonton phone systems service ? Call complete communications today!

——————————————–

High-tech solutions for easy start-up of your IPTV/OTT-business

——————————————–

——————————————–

If you want to purchase not only one item, you have a chance to enjoy privileges. There is a sale’ tab on the site which offers a fantastic range of reduced counterfeit watches and accessories, such as sunglasses, cufflinks, watch straps and pens. Luxury Jewelry Replica At MCA.MN On Sale You get a 5% discount if you buy two pieces, this discount increases to 10% if you buy 4 pieces or more. There is free international shipping on all orders on this site. We also offer customers a free return anytime with a 100% money back guarantee.

——————————————–