SQL Server Management Studio -- where is Tools/Import and Export settings menu?

In Visual Studio, there is an Import and Export settings wizard which 开发者_如何学运维you can use to customize Visual Studio and save settings to a .settings file.

Do we have something like it in SQL Server Management Studio?

I'm constantly switching between several VM's and configuring each SSMS is a pain in the neck. I want to be able to save my settings to a file, then import it in all my VM's.

Thank you.

Tools/Import and Export settings menu option disappeared from my menubar too (both for 2005 and 2008 SSMS versions), but I had and used it on my previous machine.

For now I copy my archived settings to destination like c:\Documents and Settings\gg\Moje dokumenty\SQL Server Management Studio Express\Settings\CurrentSettings-2008-09-30.vssettings.

And it works.

The Studio keeps it's settings in the registry *HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server[version of SQL Server]\Tools\Shell*. For your scenario you could export appropriate settings on one computer and deploy the reg file to any other.

Hope it helps!

Looks like MS has (essentially) acknowledged that, if this did exist, it's gone and there are no firm plans to bring it back...

From Microsoft Connect

Hi Doug, Thank you for your suggestion to import/export settings for the R2 release. We will not be considering this for R2. We have this request already on file and we'll look at it for a future release beyond R2 to address this request.

Unfortunate.

Old question, but if someone still looking for, I checked SQL 2012, Tools > Import and Export settings wizard has re-appeared. Also present in SQL 2014 and 2016.