VSTS DB Pro: Why does my “Data” menu have duplicate entries?

This is a known issue that arises when you install the VSTS DBPro GDR release while Visual Studio is open.  Microsoft is working on a fix but won’t have it in the VSTS DB Pro GDR v2 release (now out as an RC).  I’ve come across this on my VMs as well as some client installations.  It is frustrating.  I have yet to find a way to clean it all up. 

I should have known that Gert Drapers (THE Data Dude) would have a workaround for me. 

Is your Visual Studio Team System 2008 Database Edition GDR installation confused?
Does your menu suffer from multiple instance disorder?

Here is what you can do about it.

  1. Make sure that Visual Studio (devenv.exe) is closed.
  2. Start an elevated command prompt.
  3. Run the following two commands:

    “%ProgramFiles%Microsoft Visual Studio 9.0DBProDBProRepair.exe” RemoveDBPro2008
    “%ProgramFiles%Microsoft Visual Studio 9.0Common7IDEdevenv.exe” /ResetUserData

Now restart Visual Studio again, and the problem should be cured.”         -Gert Drapers

So make sure you have Visual Studio closed when installing the DB Pro GDR so you won’t have this problem in the first place.