Search code examples
sql-serverssmssql-server-2016ssms-16

Compare SSMS settings

I am wanting to compare the settings of SSMS 2016 installed on two different machines is there an easy way to this instead of pulling up each setting and going through one at a time in the GUI.

Solution

  • You could use the Import & Export Settings Wizard under the Tools menu.

    enter image description here

    The resulting file is an xml file. 

    <UserSettings>
    <ApplicationIdentity version="10.0"/>
    <ToolsOptions>
        <ToolsOptionsCategory name="Environment" RegisteredName="Environment">
            <ToolsOptionsSubCategory name="Documents" RegisteredName="Documents" PackageName="Visual Studio Environment Package">
                <PropertyValue name="ShowMiscFilesProject">true</PropertyValue>
                <PropertyValue name="AutoloadExternalChanges">false</PropertyValue>
                <PropertyValue name="CheckForConsistentLineEndings">false</PropertyValue>
            ....

    enter image description here