Apply rules from one database to another

I've gone through and catalogued all tables/columns in one database and would like to apply the same settings to all of the same tables/columns in another database. Does anyone know if I can do this through the software, without having to go through each of these by hand? Something like "Apply template" or something?

I can pull all the masked table/columns from the catalog and apply the DDL, but I want to have all this information catalogued, for our security team.

Dan_TR January 12, 2022 21:14

Comments

1 comment

Hi @Dan_TR

The following PowerShell was designed specifically for this task and should help: https://documentation.red-gate.com/sql-data-catalog/automation-with-powershell/powershell-cmdlet-reference/copy-classification

DanC January 14, 2022 11:12

0

Add comment

Please sign in to leave a comment.

How can we help you today?

Apply rules from one database to another

Comments

Add comment