SQLTeam.com | Weblogs | Forums

Data Masking in SQL 2012

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?


Run a script after the restore?


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