Synonyms: treat
rturbani
Posts: 8 Bronze 2
in SQL Compare
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.
Tagged:
Answers
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,
Alex
Have you visited our Help Center?