Mask data for an SQL Server database that resides on a Commvault client.
Before You Begin
You must have a data-masking policy defined for the instance on which you want to run a data-masking operation. For more information, see Managing SQL Server Data-Masking Policies.
Procedure
Database with the Same Name as the Original, Source Database
If you have a copy of a production database and the copy is on another instance and has the same name as the original database:
-
From the CommCell Browser, expand Client Computers > client > SQL Server.
-
Right click the instance and then select All Tasks > Data Masking > Run.
The SQL Data Masking Options dialog box appears.
-
Select the Destination Client, the Destination Instance, and the Data Masking Policy.
-
Click OK to run the data-masking policy on the database with the same name.
Database with a Different Name than the Original, Source Database
If you have a copy of a production database and the copy is on another instance and has a different name than the original database:
-
From the CommCell Browser, expand Client Computers > client > SQL Server.
-
Right click the instance and then select All Tasks > Data Masking > Run.
The SQL Data Masking Options dialog box appears.
-
Select the Destination Client, the Destination Instance, and the Data Masking Policy.
-
Select Remap Database Name on Destination.
-
Select the desired database in the DB in Policy column of the remapping table.
-
Select the desired database in the DB on Destination column of the remapping table.
-
Click OK to run the data-masking policy on the database with the different name.
Result
The software runs the data-masking policy against the databases and instances associated with the policy.