CODEWITHSUNDEEP
sql-serveretlprivacysql-server-2016
cgxanth
cgxanth

Reputation: 65

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?

Upvotes: 1

Views: 556

Answers (1)

Panagiotis Kanavos
Panagiotis Kanavos

Reputation: 131712

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

Upvotes: 1

Related Questions