Making production data accessible to developers via masking
2
votes
3
answers
1196
views
We want to provide developers in our organization masked data from production to help troubleshoot production issues.
What would be the best way to approach it?
I've read this article https://learn.microsoft.com/en-us/sql/relational-databases/security/dynamic-data-masking?view=sql-server-ver15
But it seems to take a different approach from what I've envisioned. My idea was to have a separate database server that is replicated from the production database, and somehow mask the data during replication so that the real data will never reach the replicated database server. That way we don't have to have special security considerations about how to store and treat the replicated database server.
Is it a reasonable approach?
Asked by areller
(121 rep)
Apr 2, 2020, 07:03 PM
Last activity: Apr 6, 2020, 09:42 PM
Last activity: Apr 6, 2020, 09:42 PM