Options
Options for automating/scheduling run of Data Masker set
pete29
Posts: 4 New member
Hi,
I'm able to run a masking set from within the Data Masker client, but what options would I have for being able to automate these runs? For example, if a staging database is getting overwritten nightly with production data, being able to have an automated job that can run the masking set would be quite valuable.
Tagged:
Best Answer
-
Options
TheMaskedData
Posts: 50 Bronze 3
Morning @pete29
I think what you're looking for is this: About Command Line Automation - Data Masker - Product Documentation (red-gate.com)
There's also a (now slightly old) video on the university for it: Running Data Masker from the command line - Advanced Operations with Data Masker for SQL Server - Redgate University (red-gate.com)
You can also run it with SQL Clone as part of SQL Provision for a single holistic way to refresh non-prod environments overnight: SQL Provision: Accelerate the delivery of database environments for DevOps teams (red-gate.com)
Let me know if this helps! Cheers!
Answers