Skip to content
← SQL Source Control

How can we improve SQL Source Control?

SQL Source Control: Static Data

Categories

JUMP TO ANOTHER FORUM

(thinking…)

Changes to synonyms are not detected

We use synonyms when accessing data through linked servers. If the synonym is changed to use a new linked server Source Control does not detect that change.

3 votes
Vote

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
Anonymous shared this idea  ·   ·  Report…  ·  Admin →
declined  ·  James Billings responded  · 

See comment for how to enable the requested behaviour.

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • AdminJames Billings (Admin, Redgate) commented  ·   ·  Report

    By default we ignore these, but if you go to the setup tab in SQL Source Control, and click "Comparison Options" you should be able to deselect the "Database and Server Name in Synonyms" option.
    This should then let it detect the changes you're making.