SQL Compare not finding differences between synonyms

dshort

Even after upgrading to 14.2.9.15508, it's showing a number of synonyms as 'identical' although they're clearly different.

Alex B

Hi @dshort,

One of the default comparison options is to ignore the database and server name in synonyms, so you will need to disable this option in the Options tab on the project configuration screen before running the comparison.  Just click Edit project, then click on Options tab and uncheck the box for that option ("Ignore Database and Server name in synonyms" I believe), then compare again.

Because of this option it is not showing the objects as different because it is ignoring that difference whereas the comparison view you show there is showing the textual differences and will highlight this for any textual d

Kind regards,
Alex

dshort

all set, thanks!