Change Script Generate a field called ID for each FK defined (4344982)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Change Script Generate a field called ID for each FK defined
Description

Generating a Change Script creates an additional field called [ID] for each FK defined in each table.
Cause

The extra [ID] columns on the change script appears because the tool is not relating the PK correctly.
This is because there is a mismatch between the PK Name from the Source Model and the PK of Name from the Target Database.
Resolution

Workaround #1
Change each PK name from the model to match each PK name from the database.

Workaround #2
If you want to avoid renaming each model PK name to match the database PK name
then select "Pair Primary Keys Regardless of Names" on the Generate Change Script Wizard.

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title