Run DataMasker Maskset from t-sql

Camromere

I have a currently manual process that includes running DataMasker in between two stored procedures. I was hoping there is a way to include running a DataMasker Maskset as a separate step in a SQL Server job. The steps in my manual process currently are:

Step 1 - Populate a few demo tables from production data (SQL Server stored procedure)

Step 2 - Run DataMasker against one of the demo tables (run manually from DataMasker currently)

Step 3 - Populate a few MySQL tables from production data (MySQL stored procedure called from SQL Server job step)

Step 4 - Insert masked data to a staging table on MySQL (SQL Server stored procedure)

Step 5 - Replace MySQL data in two tables with already masked data in Step 4 (MySQL stored procedure called from SQL Server job step)

These steps have to run in order and if I can figure out a way to force Step 2 to run as a separate step in a SQL job, then I can run the whole process with one sql job with five steps.

PlantBasedSQL

Hi @Camromere thank you for your post.

Data Masker can be called via the command line by a SQL Server Agent Job with a PARFILE argument, the syntax is available here: https://documentation.red-gate.com/dms/data-masker-help/general-topics/about-command-line-automation

You should use the headless runner datamaskercmdline.exe for this.

I hope this helps? Let me know if you have any additional questions on this! Thank you very much.

PlantBasedSQL

Hi @Camromere thank you for your post.

Data Masker can be called via the command line by a SQL Server Agent Job with a PARFILE argument, the syntax is available here: https://documentation.red-gate.com/dms/data-masker-help/general-topics/about-command-line-automation

You should use the headless runner datamaskercmdline.exe for this.

I hope this helps? Let me know if you have any additional questions on this! Thank you very much.