DoNotDropExtendedProperties=True not working in sqlpackage.exe #139

After playing around with turning check boxes on and off, and saving the publish profile. It seems it is possible to end up with both of these set:

<DoNotDropExtendedProperties>TrueDoNotDropExtendedProperties>
<DropExtendedPropertiesNotInSource>TrueDropExtendedPropertiesNotInSource>

To fix this using the UI, you can uncheck Drop objects in target but not in source at the top, then uncheck Drop extended properties not in source in the section below the scroll box, then re-check Drop objects in target but not in source at the top. Then hit save. This should remove the conflict.

Or to fix it manually, you could remove the DropExtendedPropertiesNotInSource element from your publish profile XML file.

This does seem like a bug...maybe. The UI should know there is a link between Do not drop extended properties and Drop extended properties not in source and should set them accordingly based on the UI.

Chad Baldwin (@chadbaldwin) thanks
True False
this setting work for me but definitely it's a bug in UI

Thanks for reporting this, Abhinay (@abhi421)! DacFx has many options, and it seems we've missed a restriction on this particular combination. As the UI is over in SSDT, I'll bring attention to this issue to that team.