Table to Table Rule

mbolufe

How can I create a Table to Table Rule when the join between the source and the target tables are like:

from Sourcetable 
join Table1 on Table1 .fkSourcetable  = Sourcetable.PK
join Table2 on Table2 .fkTable1  = Table1.PK
join Targettable  on Targettable.fkTable2  = Table2 .PK

Jon_Kirkwood

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

TheMaskedData

@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

vinay11

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.