Powershell to run Data Masking set via command line

Robb_Keller · December 4, 2018 4:18PM

I'm trying to run a Powershell script to run a data masking set. I have the following and noted the documentation did not have the path to the command line tool listed as the present naming:

& "C:\Program Files\Red Gate\Data Masker for SQL Server 6\DataMaskerCmdLine.exe" "F:\TFS\DBA\Data Masking - Obfuscation\Redgate Masking Sets\BO_TablesMasking.DMSSet" -R -D "RobbKW-10\Robb[appdev_bo] = RobbKW-10\Robb[demo]" -X | out-null

The script runs, but nothing happens. It does not seem to be running the masking set.
Anybody?

Thanks,
Robb

PlantBasedSQL · December 5, 2018 7:23AM

Thanks for your post @Robb_Keller
There is a difference between the DataMasker.exe and the DataMaskerCMDLine.exe - the former will accept the substitution of the connection string and you can specify multiple cmdline args, however the latter, which you are trying to use accepts only 1 parameter, the PARFILE.
It is specified in more detail here: https://documentation.red-gate.com/dms6/data-masker-help/version-6-tech-tips/running-data-masker-from-the-command-line
Let me know if you need any further information or if you have other questions - thank you very much.

Robb_Keller · December 4, 2018 4:35PM

I also tried running as Administrator, which did look like it triggered the DatamaskerCmdLine.exe, but did not run the script.
Robb

Robb_Keller · December 5, 2018 2:58PM

I tried to comment earlier that I did figure it out. I also had a wrong path and extension. It's working OK now. Thanks for the help.

Robb

Powershell to run Data Masking set via command line

Best Answer

Answers

Product Learning

Community Forums

Events & Friends

Simple Talk