How can we help you today? How can we help you today?

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
0

Comments

2 comments

  • DanC
    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
    0
  • miaalexandra

    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.


     

    miaalexandra
    0

Add comment

Please sign in to leave a comment.