Competition: What’s your favorite Redgate tool? Enter now.

Run DataMasker Maskset from t-sql

I have a currently manual process that includes running DataMasker in between two stored procedures. I was hoping there is a way to include running a DataMasker Maskset as a separate step in a SQL Server job. The steps in my manual process currently are:

Step 1 - Populate a few demo tables from production data (SQL Server stored procedure)
Step 2 - Run DataMasker against one of the demo tables (run manually from DataMasker currently)
Step 3 - Populate a few MySQL tables from production data (MySQL stored procedure called from SQL Server job step)
Step 4 - Insert masked data to a staging table on MySQL (SQL Server stored procedure)
Step 5 - Replace MySQL data in two tables with already masked data in Step 4 (MySQL stored procedure called from SQL Server job step)

These steps have to run in order and if I can figure out a way to force Step 2 to run as a separate step in a SQL job, then I can run the whole process with one sql job with five steps.


Tagged:

Answers

Sign In or Register to comment.