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

Synonyms: treat

We use synonyms a lot when we do major upgrades to make things backwards compatible.  So it would be really nifty if there were a way to tell SQL Compare to do the compare (when possible) ignoring the type of the object; eg., if in database/server 1, object a.b is a table, and in database/server 2, object a.b is a synonym, include a.b in the "things that exist in both places" group, and show that, hey, it's a table here and synonym there.


  • Options
    Alex BAlex B Posts: 1,146 Diamond 4
    Hi @rturbani,

    Unfortunately that isn't possible since they are both distinct object types that are compared separately from each other. 

    You do have the ability to map tables with different names to each other (and it may auto-map in some cases), so if the synonym is for a differently named table you could just map the tables together when setting up the project:

    And then they appears like this

    If that doesn't help or you would like to see the other functionality, you can create a suggestion on the Uservoice forum https://redgate.uservoice.com/forums/141379-sql-compare for the team to consider.

    I hope that helps!

    Kind regards,


    Product Support Engineer | Redgate Software

    Have you visited our Help Center?
  • Options
    rturbanirturbani Posts: 8 Bronze 2
    Thanks Alex...I'll give mapping a try...as well as submit a suggestion.
Sign In or Register to comment.