Voltar
-
Título
Change Script Generate a field called ID for each FK defined -
Descrição
Generating a Change Script creates an additional field called [ID] for each FK defined in each table. -
Causa
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. -
Resolução
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.