How to match Relationships with role named Columns in Complete Compare? (4218117)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

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.
Resolution

To remedy this simply check the box 'Using Name Matching' in Advanced Options in Complete Compare Wizard.
Defect ID

LH1-I235

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title