Change the server that the database is linked too.

wsorannowsoranno Posts: 65
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
[email protected]

"Quality, like Success, is a Journey, not a Destination" - William Soranno '92

Comments

  • 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
  • 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
    [email protected]

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