Options
Running Powershell script to Automate Datamasker
vinay11
Posts: 15 New member
Hi Team,
To Automate the Datamasker using Power shell.
Step1 : Created Par file as below
Step2:
used below script in power shell
Concern :
Running Above script i can able to open the Maker file "OSBDMASKSQLD01_DMaskTest (14).DMSMaskSet".
But not clear on how to Run and schedule to automate the same . Please suggest the way or any Document video reference
To Automate the Datamasker using Power shell.
Step1 : Created Par file as below
MASKINGSET=H:\scripts\Maskercatalog\OSBDMASKSQLD01_DMaskTest (14).DMSMaskSet
LOGFILEDIR=H:\scripts\Maskercatalog\Log Files
REPORTSDIR=H:\scripts\Maskercatalog\Log Files
DATASETSDIR=C:\Program Files\Red Gate\Data Masker for SQL Server 7\DataSets
INTERIM_REPORTS=true
Step2:
used below script in power shell
$parfile="H:\scripts\Maskercatalog"
&'H:\scripts\Maskercatalog\OSBDMASKSQLD01_DMaskTest (14).DMSMaskSet' run --parfile $PARFILE
Concern :
Running Above script i can able to open the Maker file "OSBDMASKSQLD01_DMaskTest (14).DMSMaskSet".
But not clear on how to Run and schedule to automate the same . Please suggest the way or any Document video reference
Tagged:
Answers
Simply create a PowerScript as per the following example:
Obviously amend the path to the PARFILE as per your requirements.
Save the script asd a *.ps1 file.
Use the Windows Task Scheduler to trigger the PowerShell ps1 script at the day and time you wish the masking to take place.
Many Thanks
Eddie
Many Thanks
Eddie
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com