Table to Table Rule

• 

  Hi there and thanks for reaching out on the Redgate forums regarding your Datamaster query

  It looks like you would need to create a masking rule which would join the tables as you have outlined
  

  
  

  Details on creating masking rules can be found on our documentation site:

  https://documentation.red-gate.com/dms/data-masker-help/masking-rules
  

  
  

  For the same database under the same scheme, then you probably should create Table-to-Table Synchronization Rules to achieve that. More information about it: 
  

  https://documentation.red-gate.com/dms/data-masker-help/masking-rules/table-to-table-synchronization-rules
  

  
  

  If you are working across databases this page may be of use too:

  https://documentation.red-gate.com/dms/data-masker-help/masking-rules/cross-database-table-to-table-rules

  Jon_Kirkwood January 07, 2022 06:51

  - 0 +
• 
  @mbolufe you will most likely need a Sync-Manager rule for this if there is no common join between the tables on the tables themselves.
  
  Data Masker will create the common table between them and sync the values across consistently so just convert your substitution rule to a sync manager instead of using the Table-to-Table sync itself

  TheMaskedData April 01, 2022 09:00

  - 0 +
• 
  Hi Team,  Please guide on how to process Cross DB TAble to Table Data Masker Rules. Redgate site i got only the documents. Please share the course link on Data Masker to process All Rules.

  vinay11 June 27, 2022 10:16

  - 0 +

Add comment

Please sign in to leave a comment.