Update linked server names

sergey68sergey68 Posts: 7
edited February 22, 2011 7:50PM in SQL Compare Previous Versions
Here is a scenario I am trying to handle. We have some stored procedures that refer to linked servers by name. Those names differ between server instances of the database in question. Is there any way to handle this in SQ Compare? I know DB project in VS has this macro substition fetaure, but is there something like this in SQL Compare?

Thank you.
Sergey.
Sergey Barskiy, Software Developer
· Share on Twitter

Comments

  • James BJames B Posts: 1,124 Silver 4
    Hmm, I don't think there is a quick way around this.

    Some people use Synonyms to refer to other server objects and then these can be named the same throughout your databases. The only difference is how they are defined (and there is an option to ignore server/database names in Synonyms in Compare).

    Not sure how useful that is for you, but it's perhaps worth investigating?
    Systems Software Engineer

    Redgate Software

    · Share on Twitter
  • sergey68sergey68 Posts: 7
    Thanks, James. I was hoping for something similar to what DB project provides, but I will certainly look into synonyms.
    Sergey Barskiy, Software Developer
    · Share on Twitter
Sign In or Register to comment.