VS2010 Server Explorer data connections: where are they registered or stored? How to edit them?

Question

We changed the database server, and as a result, all data connections point to the wrong server. I want to edit them to change the server, but the only thing I can do is delete and recreate them. Not good.

Where is their definition stored so that I can change them?

Answer 1

I found the file in which they are stored: It %AppData%\Roaming\Microsoft\VisualStudio\10.0\ServerExplorer\DefaultView.SEView , but ConnectionStrings are encrypted, so you cannot change them: (

In VS15, this is %AppData%\Microsoft\VisualStudio\14.0\ServerExplorer\DefaultView.SEView , but ConnectionStrings are still encrypted