Options for automating/scheduling run of Data Masker set

pete29

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.

TheMaskedData

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!

pete29

Thanks, TheMaskedData!  I'll take a look at the documentation and will follow up here if I run into any questions or difficulties.