Comments
2 comments
-
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 -
To apply rules (like validation or conditional formatting) from one database to another, you'll need to identify the specific rules you want to transfer and then implement them in the target database. This often involves exporting the rules from the source database and then importing them or recreating them in the Spacebar clicker target database.To apply rules (like validation or conditional formatting) from one database to another, you'll need to identify the specific rules you want to transfer and then implement them in the target database. This often involves exporting the rules from the source database and then importing them or recreating them in the target database.Format Painter copies formatting rules! Another easier way would be to edit the rule to include the column you want to copy the formatting to.
Add comment
Please sign in to leave a comment.
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.