Search code examples
sql-serverssmssql-server-2014ssms-2014

Does the Poor Mans T-SQL formatting add-in for Management Studio 2012 work in Management Studio 2014?

Does the Poor Mans T-SQL formatting add-in for Management Studio 2012 work in Management Studio 2014?

In SSMS 2012, if I go to tools, it showed up in the list. In SSMS 2014, it doesn't.

I tried to run the installer again, and it gave me options to repair or uninstall. I had the formatter installed prior to installing 2014.

EDIT: The tool is available here.

Solution

  • Create the folder 

    %SystemDrive%\ProgramData\Microsoft\SQL Server Management Studio\12.0\Addins\

    if it does not exist. Then just copy the file from:

    %SystemDrive%\ProgramData\Microsoft\SQL Server Management Studio\11.0\Addins\PoorMansTSqlFormatterSSMSAddIn.AddIn

    to

    %SystemDrive%\ProgramData\Microsoft\SQL Server Management Studio\12.0\Addins\PoorMansTSqlFormatterSSMSAddIn.AddIn