Visual Studio 2013 loses data connections I added
server-explorer, visual-studio-2013
Solution
I don't remember where I found the information (I'm pretty sure it was stackoverflow, though) but here is what I have done.
- I open Visual Studio with no project.
- Go to server explorer and add the databases
- CD to C:\Users\\AppData\Roaming\Microsoft\VisualStudio\12.0\ServerExplorer
- Make a copy of the file DefaultView.SEView
- Then, if ever I lose any, I can just copy my backup over the DefaultView.SEView file and they are all back.
Problem
I haven't been able to determine a pattern, but I keep losing data connections I've added in the Server Explorer. I have a set of about 20-25 databases I connect with regularly, so I set them up in the server explorer so I don't have to do it each time I open the IDE. How can I either prevent this loss, or automatically re-add them so I don't have to manually do this every time VS loses them?