SQL Compare not finding differences between synonyms

dshortdshort Posts: 10 Bronze 2
in SQL Compare
Even after upgrading to 14.2.9.15508, it's showing a number of synonyms as 'identical' although they're clearly different.
Tagged:
· Share on Twitter

Best Answer

  • Alex BAlex B Posts: 1,158 Diamond 4
    Answer ✓
    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
    Product Support Engineer | Redgate Software

    Have you visited our Help Center?
    · Share on Twitter

Answers

Sign In or Register to comment.