Sample Header Ad - 728x90

SQL Server replication with masking columns

1 vote
0 answers
41 views
Using a sql server, I have to replicate the database 'source' to the 'target'. It will be a pull subscription, ran as agent on the target. Some of the columns will have to be masked, so not to be shown to users at the 'target'. > 1.) I know how to do masking, using alter table alter column command > 2.) I know to make sure the user on the 'target' is denied unmask permissions The question I have is such: The database on the 'source' existed for a long time, and the columns are currently not masked. Do I need to specifically run alter table alter column on every table/column I need it on ? before setting up the snapshot replication publication ? Or is there an option to mask specific columns at the time the snapshot is created ?
Asked by Dmitriy Ryabin (111 rep)
Jan 22, 2025, 08:31 PM