We are going through our migration process and have removed many of the orphaned tr_xref records that created associations we no longer care about.
Now that we have cleaned this how does one regenerate the tru_association table to reflect the now required mapping?
Thank you...
Michael
Michael,
The most complete way is to truncate the tru_association_mapping table, then run the Migration - Check Database report. This will re-populate the table with the currently existing pairs.
David
Unknown said: The most complete way is to truncate the tru_association_mapping table, then run the Migration - Check Database report. This will re-populate the table with the currently existing pairs.
This loses your mapping, though. We've been saving the contents to a temp table, truncating tru_association_mapping, running the Check report, then updating our mapping id's back to the tru_ table.