Can data generator change existing data in selected columns while preserving the rest in a table?
Dar
Posts: 2 Bronze 1
Can data generator change existing data in selected columns while preserving the rest in a table?
Tagged:
Answers
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!