Powershell to run Data Masking set via command line

Robb_Keller

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

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

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

Robb_Keller

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