Old decommissioned servers in Source/Target dropdowns

• 
  I too was wondering this only today!  my list is a bit of a mess and would like to tidy it up

  BTP July 27, 2020 09:58

  - 0 +
• 
  Hi @tsoren and @BTP
  
  I've done some testing around this and found you can remove the entries for the local SQL Servers and Azure servers from HKEY_CURRENT_USER > Software > Red Gate >SQL Compare 14 >MostRecentlyUsedServers and HKEY_CURRENT_USER > Software > Red Gate >SQL Data Compare 14 >MostRecentlyUsedServers
  
  However if you're seeing servers in the network section, we don't save these, I found I had references in my registry if I searched for the instance name and removed them. 
  
  Please then close and re-open SQL Compare and Data Compare to refresh!
  
  
  

  DanC July 27, 2020 14:47

  - 0 +
• 
  As rummaging in the registry is fraught with danger for some, I feel this could be a feature that can be added to maintain this list
  
  

  BTP July 27, 2020 14:49

  - 0 +
• 
  Hi @BTP
  
  I can understand that, I would recommend posting the suggestion on the forum here: https://redgate.uservoice.com/forums/141379-sql-compare
  
  This is where the Product Managers look for new ideas for improvements to the products

  DanC July 27, 2020 15:05

  - 0 +
• 
  Dan, thanks for the info to clear from the Red Gate registry entries.  Still having entries in the network section.  You mention finding you had other references in your registry and removed them, do you recall where you found them?  Do you have any info on how Red Gate internally loads these "Network Servers" from?  The first couple of servers I have searched for are not showing up when searching my entire registry.  Thanks!
  

  tsoren August 01, 2020 19:19

  - 0 +
• 
  Hi @tsoren
  
  You're welcome! I'm not quite sure where I found the references precisely, but I searched for the instance names and deleted all references. I can query the development team on how the Network Servers get found and stored.

  DanC August 03, 2020 09:21

  - 0 +
• 
  Dan, that would be great, as the first 3 server instances I tried I couldn't find anywhere in registry. Thanks!

  tsoren August 03, 2020 13:13

  - 0 +
• 
  Hi @tsoren
  
  I queried the developers and was informed that all our tools share a library to discover servers. The library users a number of strategies which includes using the SQL Browser service and the registry. 
  
  Unfortunately you're unable to remove items from the list.
  
  Sorry I couldn't of been more help!
  
  

  DanC August 05, 2020 13:17

  - 0 +
• 
  Hi Dan!
  Actually your last answer was more helpful than you realized.  By mentioning using SQL Browser triggered me to look at the registered servers on my SSMS and I found that a while ago I had moved them into a Server Group by site called Deprecated.  Once I deleted these entries, it fixed the drop downs on Red Gate Compare and Data Compare.  Thanks for your help!

  tsoren August 07, 2020 15:30

  - 0 +
• 
  Hi @tsoren
  
  Ah brilliant, glad that resolved the issue for you and I'll certainly make a note for that to be something to review in the future!

  DanC August 07, 2020 15:36

  - 0 +

Add comment

Please sign in to leave a comment.