What are the challenges you face when working across database platforms? Take the survey
Options

Can data generator change existing data in selected columns while preserving the rest in a table?

DarDar Posts: 1 New member
Can data generator change existing data in selected columns while preserving the rest in a table? 
Tagged:

Answers

  • Options
    Hi @Dar thank you very much for your post.

    SQL Data Generator is intended purely for the generation of full sets of synthetic, random data into tables for processes such as load testing or as part of the DevOps pipeline.
    The technique you appear to be referencing is Data Masking, or de-identification i.e. the ability to mask potentially sensitive or unwanted columns, but preserve other columns that contain useful business information that could be useful in say, development or testing environments (instead of doing a copy down of live).

    If this is the case, then Redgate offers a solution called SQL Provision: https://www.red-gate.com/products/dba/sql-provision/
    This solution contains Redgates Data Masking component (which offers the above functionality) and also the Cloning module "SQL Clone" which allows you to easily, with a low time and disk space footprint, spin up any of these sanitized databases into lower environments.

    There's a great number of video resources for data masker here: https://www.red-gate.com/products/dba/data-masker/resources/ and a great (fun) video for SQL Clone from Redgate Streamed here: https://www.youtube.com/watch?v=mB91ycVW2u4

    Let me know if you need any more info! Thank you very much!
Sign In or Register to comment.