Redgate simplifies data masking with database provisioning tool
(firmenpresse) - Cambridge UK, Monday, December 18, 2017 ioning 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:
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.
Themen in dieser Pressemitteilung:
Unternehmensinformation / Kurzprofil:
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.
Karis Brummitt, Product Marketing Manager, Redgate Software
Karis.Brummitt(at)red-gate.com
Matt Hilbert, Technology Writer, Redgate Software
Matt.Hilbert(at)red-gate.com
07564 778274
Datum: 18.12.2017 - 10:39 Uhr
Sprache: Deutsch
News-ID 1530663
Anzahl Zeichen: 2984
contact information:
Contact person: Fran Cator
Town:
Lincoln
Phone: +44 (0)1522 883640
Kategorie:
Computer & Software
Typ of Press Release: bitte
type of sending: Veröffentlichung
Date of sending:
Anmerkungen:
Diese Pressemitteilung wurde bisher 562 mal aufgerufen.
Die Pressemitteilung mit dem Titel:
"Redgate simplifies data masking with database provisioning tool
"
steht unter der journalistisch-redaktionellen Verantwortung von
RealWire (Nachricht senden)
Beachten Sie bitte die weiteren Informationen zum Haftungsauschluß (gemäß TMG - TeleMedianGesetz) und dem Datenschutz (gemäß der DSGVO).
