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

sql visual-studio ssms application-settings
tempid picture tempid · Apr 7, 2011 · Viewed 32k times · Source

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

Grzegorz Gierlik picture Grzegorz Gierlik · Jun 2, 2011

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.

Related questions

How can I do SELECT UNIQUE with LINQ?

I have a list like this: Red Red Brown Yellow Green Green Brown Red Orange I am trying to do a SELECT UNIQUE with LINQ, i.e. I want Red Brown Yellow Green Orange var uniqueColors = from dbo in database.…

Read More
DataSet panel (Report Data) in SSRS designer is gone

In the layout screen of an SSRS designer e.g. Visual Studio, I have lost the report data panel. It has disappeared and I can't remember what it is called in order to get it back. This usually lists the …

Read More
Update DataSet structure in Visual Studio to match new SQL Database Structure

After making some changes to my SQL database structure (using scripts in SQL Server Management Studio), how can I update my DataSet.xsd file in Visual Studio to match the new structure? Must I do this manually? I considered deleting …

Read More