How to match Relationships with role named Columns in Complete Compare?
説明
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?
原因
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.
対策
To remedy this simply check the box 'Using Name Matching' in Advanced Options in Complete Compare Wizard.