How can we help you today? How can we help you today?

Local DB unlinks from source control every time SSMS is closed

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.
rpaul
0

Comments

1 comment

Sort by
  • Dan_J
    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?



    Dan_J
    0

Add comment

Please sign in to leave a comment.