What are the challenges you face when working across database platforms? Take the survey

SQL Compare not finding differences between synonyms

dshortdshort Posts: 10 Bronze 2
Even after upgrading to, it's showing a number of synonyms as 'identical' although they're clearly different.

Best Answer

  • Options
    Alex BAlex B Posts: 1,146 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,
    Product Support Engineer | Redgate Software

    Have you visited our Help Center?


Sign In or Register to comment.