Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to copy SSMS connections in dropdown to a new computer?

I'm getting an upgraded laptop at work and my old machine had SSMS 17.9 with several dozen dbengine connections with pwds in the dropdown for dbengine Connection.

Are these in the registry, ini file, Windows Credential manager? I would like to be able to copy them to the new machine. I'm even ok if I have to re-enter the passwords--the servernames are really a bigger deal to me. Thanks,

like image 965
jimo3 Avatar asked Sep 19 '25 15:09

jimo3


1 Answers

You can copy from the old computer to the new one from the following path: %userprofile%\AppData\Roaming\Microsoft\SQL Server Management Studio\18.0\UserSettings.xml

(18.0 its the SSMS version, it may vary from each specific case)

like image 148
Ivan-San Avatar answered Sep 21 '25 14:09

Ivan-San