Local DB unlinks from source control every time SSMS is closed

rpaulrpaul Posts: 7 New member
edited July 21, 2021 2:52PM in SQL Source Control
Every time I reopen SQL Server Management Studio my local database is no longer connected to source control. The database is not rebuilding or anything, it is persistent, so I'm not sure what's going on. The xml and ssc files are still in my repo folder so it relinks without me having to delete the folder content. I am using Git for source control. 
Tagged:
· Share on Twitter

Answers

  • Dan_JDan_J Posts: 464 Silver 2
    Hi @rpaul

    I'm sorry to hear you are experiencing this issue with SQL Source Control! Thanks for reaching out to us on this.

    SQL Source Control stores information about linked databases in the following location/file:
    %localappdata%\Red Gate\SQL Source Control 7\LinkedDatabases.xml.

    Would you mind checking if this file is getting updated when you link a database?  If not, can you please check the permissions on the file?

    Also, is this happening to every database you link? If you create a blank database and then link it to a new working folder, is there an entry for it added to the LinkedDatabes.xml file?  If so, does it remain linked and in the file after restarting SSMS?



    Kind regards

    Dan Jary | Redgate Software
    Have you visited our Help Center?
    · Share on Twitter
Sign In or Register to comment.