3

I use Visual Studio 2005, 2008, and 2010 for various projects. Is there any way to export the saved Data Connections that I have in the Server Explorer pane on one version, and import them into the other versions?

I took a look at the Import and Export Settings Wizard, and it has a section for Database Tools, but there's no mention of the saved connections.

travis
  • 35,751
  • 21
  • 71
  • 94
  • 1
    I did come across this question, but it's only referring to different instances of 2010: http://stackoverflow.com/questions/5173406/transferring-saved-data-connections-between-visual-studio-installations – travis Mar 30 '11 at 16:09
  • Yeah, it would be helpful to know for all versions. I haven't been able to find anything. – Jon Mar 30 '11 at 19:00

1 Answers1

3

I found a text based file that contains my connections: C:\Documents and Settings\Your Profile name goes here\Application Data\Microsoft\VisualStudio\9.0\ServerExplorer\DefaultView.SEView

I don't know how well it ports into the next version but it's a start. At least his has the text based names of your servers.

Aaron Mclean
  • 31
  • 2
  • Nice, that's a step in the right direction. Unfortunately it looks like the rest of the Connection String is encrypted. – travis May 16 '11 at 14:32