1

Closed

Diff api - changes to FK actions not detected

description

I have a problem when I change a existing foreign key. Only added and deleted FKs are considered. We changed an existing foreign key and no script for this foreign key changes have been generated.
For example: The origion constraint looks like this
ALTER TABLE [RecipeSetValueRowSet]
ADD CONSTRAINT [FK_RecipeRecipeSetValueRow]
FOREIGN KEY ([RecipeId])
REFERENCES [RecipeSet]
([Id])
ON DELETE NO ACTION ON UPDATE NO ACTION;
 
We changed the ON DELETE to CASCADE and no update script is generated in this case.
Closed Dec 5, 2015 at 12:08 PM by ErikEJ
Moved to github

comments