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

Question

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.

Answer 1

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.

Answer 2

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!