SQLTeam.com | Weblogs | Forums

Data Masking in SQL 2012


#1

Hi,
this is related to Data masking in SQL 2012.
we have a SSR set up that restore data from prod to dev enviroment.
we want to mask certain fields in the tables of the database.we cannot update SSR due to permission.is there a way wherein we can mask data?

Thanks!


#2

Run a script after the restore?

?


#3
  1. who is accessing the data in this restored environment
  2. how are they accessing it (via query, via a web portal, ssrs)