Ignore MASKING FUNCTION on columns
Dynamic masking functionality is new to SQL 2016. It is applied on columns.
https://docs.microsoft.com/en-us/sql/relational-databases/security/dynamic-data-masking
Great for DEV and UAT environments where data obscurity is required.
CREATE TABLE Membership
(MemberID int IDENTITY PRIMARY KEY,
FirstName varchar(100) MASKED WITH (FUNCTION = 'partial(1,"XXXXXXX",0)') NULL, *ignore these
LastName varchar(100) NOT NULL,
Phone# varchar(12) MASKED WITH (FUNCTION = 'default()') NULL,
Email varchar(100) MASKED WITH (FUNCTION = 'email()') NULL);
Ideally we need this ignored in SQL Compare and SQL Source control comparisons so it is not accidentally deployed to production.
![](https://secure.gravatar.com/avatar/8d4f5825234c193d83e34da9d33c66b2?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)
Thanks for the suggestion David, this was released today in Compare 14.1.2.
Any feedback or further suggestions do let us know.
Tim