Change the server that the database is linked too.

wsorannowsoranno Posts: 65
edited July 24, 2012 12:03PM in SQL Source Control Previous Versions
My Team Foundation Server has been rebuilt with a new name.
Is there an easy way to edit the server portion of the link with out unlinking and then linking each database?
Thanks
Bill Soranno
MCP, MCTS, MCITP DBA
Database Administrator
Winona State University
Maxwell 143
wsoranno@winona.edu

"Quality, like Success, is a Journey, not a Destination" - William Soranno '92
· Share on Twitter

Comments

  • David AtkinsonDavid Atkinson Posts: 1,462 Rose Gold 2
    Good question. You could try editing C:\Users\%username%\AppData\Local\Red Gate\SQL Source Control 3\LinkedDatabases.xml

    David
    David Atkinson
    Product Manager
    Redgate Software
    · Share on Twitter
  • wsorannowsoranno Posts: 65
    David,
    Thanks for the suggestion. Editing the file worked great.
    I was able to do a find and replace.
    When I restarted SSMS, the links were correct.
    Suggestion for a future release.
    Next to the "Unlink database..." add an Edit Link.
    Thanks
    Bill Soranno
    MCP, MCTS, MCITP DBA
    Database Administrator
    Winona State University
    Maxwell 143
    wsoranno@winona.edu

    "Quality, like Success, is a Journey, not a Destination" - William Soranno '92
    · Share on Twitter
Sign In or Register to comment.