How can we help you today? How can we help you today?

Powershell to run Data Masking set via command line

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
Robb_Keller
0

Comments

3 comments

Sort by
  • 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
    0
  • 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.
    PlantBasedSQL
    0
  • 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
    Robb_Keller
    0

Add comment

Please sign in to leave a comment.