1

We used to have multiple environments for applications such as Production, Staging, UAT, Dev, and Sandbox. It is a regular task for the DBA to refresh the lower (staging, test, UAT etc.) environments with a backup of the production database backup. Sometimes we need to share the database backup with the external vendors as well.

How to Apply Static Data Masking With Replication of Databases , i.e for every change the replication database to to apply mask and save masked records in staging, test, UAT etc.

Is there any tools or process or methods available ?

Ramakrishna.p
  • 113
  • 6

1 Answers1

2

These are out of the box features of SQL Server so you'll essentially need to follow the Microsoft Books Online and other resources on setting them up. Replication has a lot of small steps and basic prerequisites but it's essentially a wizard, so it's rather simple if you just follow the documentation carefully.

Here's some helpful references for setting up Replication:

  1. Microsoft Books Online - SQL Server Replication

  2. Quick walkthrough on setting up Replication

  3. More in depth walkthrough for setting up Replication

And here's some good resources on implementing Static Data Masking:

  1. Microsoft Books Online - Static Data Masking for Azure SQL Database and SQL Server

  2. SQL Server Static Data Masking Example

  3. Static Data Masking in SSMS 18

Please note that Static Data Masking is only available in SQL Server 2019 (or equivalent Azure SQL Database version). So if you're on an older version of SQL Server, the alternative option available is called Dynamic Data Masking.

J.D.
  • 40,776
  • 12
  • 62
  • 141