Search code examples
sql-serveretlprivacysql-server-2016

Equivalent to Oracle Data Masking in SQL Server?

I used to work with Oracle ETL/database tools and now I have transferred to a Microsoft working environment. In Oracle SQL Developer there was a feature named Data Masking which would mask selected column values with *** characters. Is this also possible with Microsoft SQL Server 2016?

Solution

  • As others commented, you are probably looking for Dynamic Data Masking which is available in all versions of SQL Server 2016 SP1, even Express and the embedded LocalDB. The equivalent in Oracle is Data Redaction

    You'll find a nice overview in Use Dynamic Data Masking to obfuscate your sensitive data