Retour
-
Titre
How to match Relationships with role named Columns in Complete Compare? -
Description
If there are more than one Relationships between the same two Tables and one of them is role named, those are misaligned when doing a Complete Compare with either a model or a database, even though the Relationships names and their members are matching. How to align them during Complete Compare? -
Cause
This is because Complete Compare aligns the Foreign Key (FK) constraints using the members first and the names next. If the corresponding Primary Key (PK) and FK column names are different this causes misalignment. -
Résolution
To remedy this simply check the box 'Using Name Matching' in Advanced Options in Complete Compare Wizard. -
Identifiant du défaut
LH1-I235