13

I have Visual Studio 2005 Team Edition for DB Professionals.

After starting "Data --> Schema Compare --> New Schema Comparison...", i can choose a database from a DropDown. Unfortunately there are some old references that i don't need anymore. How can i delete those entries?

9 Answers 9

25

I did recognize that the connections are stored in the Server Explorer. "View --> Server Explorer". The Data Connections stored there can be deleted.

Sign up to request clarification or add additional context in comments.

1 Comment

Unfortunately this didn't work for me - it appeared to work, but the deleted connection would re-appear when the solution was reloaded. It turns out the resolution to my problem was really simple: there were references to connectionstrings in my web.config, and this is what was being used when populating the list in Server Explorer!
7

You can manage them from the registry: HKEY_CURRENT_USER\Software\Microsoft\VisualStudio\12.0\SSDT\ConnectionMruList

Comments

3

Yes can view your added schemas in the "Server Explorer" in Visual Studio. Just, right-click the schema and delete it.

Comments

2

In the select schema connection window, click edit connection for the connection you don't want. The set it to a connection you already have and still want, this tricks it into removing itself.

It's the only way I've got them to remove!

1 Comment

Same here, they don't appear in the Server Explorer (VS 2015 and maybe 2013)
2

For Visual Studio 2017:

  • Right click on your project in the Solution Explorer.
  • Select Properties.
  • Click the Settings option in the left menu pane.
  • Right click on the connection you want to remove.

KerPOW! Done! Gone!

Comments

1

For Visual Studio 2015 MRU connections are stored here: HKEY_CURRENT_USER\Software\Microsoft\VisualStudio\14.0\ConnectionMruList

1 Comment

Make sure you close visual studio when you delete.
0

I am using Visual Studio 2012. I have clicked on Project and Select the name of project on dropdown menu e.g. MyDemo Properties. On the side menu click settings then you will find connection string listed in a table then Delete those you don't need.

Comments

0

You need to go into your web.config file and find the tag. You'll see all of your old and current connections in there you can delete the ones you no longer need.

Comments

0

None of the above worked for me in VS 2015. I could not find the registry entry mentioned. Only the following steps worked for me:

  1. Delete any forms that rely on datasets you will delete.
  2. Delete datasets that rely on the connections.
  3. Remove all connection strings from app.config.
  4. Remove all "settings" from the project properties setting tabs.
  5. Delete all data connections in server explorer (View->Server Explorer).
  6. Rebuild the project.

Now when you add a new Data Source all the connections in the dropdown are gone.

As another user mentioned above, deleting the data connections in the server explorer is not enough. When you exit VS and re-enter they come right back.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.