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

Data Masker Powershell

Folks,

I'm trying run a Data Masking Set through Powershell, as we will be pushing out masking from a central location.  I've tried the code on the current help page 
https://www.red-gate.com/hub/product-learning/sql-clone/how-to-automatically-provision-sanitized-data-using-sql-clone-data-masker-and-powershell

That page references an application in \Red Gate\Data Masker for SQL Server\DataMasker.exe, but I have a different path/application: \Red Gate\Data Masker for SQL Server 6\DataMaskerCmdLine.exe.

Has anyone been successful running Powershell to execute the Data Masker and run a masking set from code like:
If (-NOT ([Security.Principal.WindowsPrincipal][Security.Principal.WindowsIdentity]::GetCurrent()).IsInRole([Security.Principal.WindowsBuiltInRole] "Administrator"))
{   
## $arguments = "& '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 -X | out-null"
Start-Process powershell -Verb runAs -ArgumentList "& '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"
Break
}
??

Thanks,
Robb


Robb_Keller
0

Comments

2 comments

Sort by
  • Robb_Keller
    The above Powershell opens the application briefly, but does not run the masking set.  Thanks,Robb
    Robb_Keller
    0
  • Robb_Keller
    Folks!
    I finally got the Powershell to run the data masking.  I was referencing the wrong app, which IS DataMasker.exe, NOT DataMaskerCmdLine.exe.  The file was wrong on extension too.

    Thanks anyway for consideration, but I'm good to go.

    Robb
    Robb_Keller
    0

Add comment

Please sign in to leave a comment.