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.
Comments
2 comments
-
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! -
Thanks, TheMaskedData! I'll take a look at the documentation and will follow up here if I run into any questions or difficulties.
Add comment
Please sign in to leave a comment.