Basic Data Masking for Development Work Using SQL Clone and SQL Data Generator

Basic Data Masking for Development Work Using SQL Clone and SQL Data Generator

http://ift.tt/2rxBgkL

This article describes a lightweight copy-and-generate approach for making a sanitized version of a production database available to development teams with SQL Clone and SQL Data Generator.

We build the latest database version (schema only), then copy into it, from the production database, the data for any tables and columns that don’t require masking. For columns containing sensitive or identifying data, we generate the data instead.

java

via DZone.com Feed https://dzone.com

May 19, 2017 at 06:09AM

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s