I have selected the option to 'ignore extended properties', but the generated script still includes them.
How do I do to avoid having to manually edit the script to remove all the extended properties?
SQL Schema compare always includes views extended properties
Thanks for the question.
When the 'ignore extended properties' option is selected, the source extended properties will not be created, but the target extended properties will be saved. When you are using any ignore option, it means you do not want to synchronize the ignored objects, but you want to preserve them in the target. That's why your script contains the extended properties. If you don't need the extended properties, remove them from the target or do not create in the source, and use 'Ignore Extended Properties' option. If the extended properties from the source exist in the script when the 'Ignore Extended Properties' option is selected, this is a bug. Send us an example, and we will fix it.
To solve the problem, we have to synchronize the extended properties as the independent object. We will take your suggestion into account while developing our next product version.
When the 'ignore extended properties' option is selected, the source extended properties will not be created, but the target extended properties will be saved. When you are using any ignore option, it means you do not want to synchronize the ignored objects, but you want to preserve them in the target. That's why your script contains the extended properties. If you don't need the extended properties, remove them from the target or do not create in the source, and use 'Ignore Extended Properties' option. If the extended properties from the source exist in the script when the 'Ignore Extended Properties' option is selected, this is a bug. Send us an example, and we will fix it.
To solve the problem, we have to synchronize the extended properties as the independent object. We will take your suggestion into account while developing our next product version.