What are the challenges you face when working across database platforms? Take the survey

How to make masking rule?

I am not sure the data(ex: 'test comment') where it is in db.
but I need to mask the data (ex: 'masked comment').
How can I create rule for this?
Hope to hear soon.
Kind regards.


  • Options
    Eddie DEddie D Posts: 1,789 Rose Gold 5
    Hi Kayden,
    Thank you for your forum post.

    The rule you most likely need to use will be the Search and Replace rule, further details here.

    However, you will need to identify the tables that include text you wish to replace and create a Search and Replace rule for each table

    Data Masker cannot apply the Search and Replace across all tables in a single rule.

    Many Thanks
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
Sign In or Register to comment.