SQL Compare is not comparing synonyms properly

I am comparing db schemas across 2 different db servers. I know for a fact that the synonyms have different definitions in those 2 locations but SQL Compare is not detecting it. It only seems to catch the differences at the beginning on the synonym but not in the middle.

For example, these values are identified properly as different:
db1: CREATE SYNONYM [cmms].[Assets] FOR [OracleEmulator].[dbo].[JP_ASSETS]

But, these values are not identified properly and are categorized as identical in the comparison output:
db1: CREATE SYNONYM [sugar].[accounts] FOR [sugar].[sugar].[dbo].[accounts]
db2: CREATE SYNONYM [sugar].[accounts] FOR [sugar].[sugartest].[dbo].[accounts]


  • sam.blackburnsam.blackburn Posts: 224 Gold 2
    edited May 26, 2017 3:58PM
    This could be caused by the "ignore database and server name in synonyms" option which is enabled by default. Could you check your project options?

    Software Developer
    Redgate Software
Sign In or Register to comment.