SQLTeam.com | Weblogs | Forums

Data Masking in SQL 2012

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!

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)