CODEWITHSUNDEEP
sql-serverssmssql-server-2014ssms-2014
Hoppe
Hoppe

Reputation: 6805

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.

Upvotes: 56

Views: 38291

Answers (5)

McLoo
McLoo

Reputation: 13

With SSMS 18.10 I successfully got Poor Man's T-SQL Formatter working applying the proposed fix from https://github.com/TaoK/PoorMansTSqlFormatter/issues/234#issuecomment-1264508689

Add the following (missing) tags to C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\Ssms.exe.config

    <dependentAssembly>
        <assemblyIdentity name="Microsoft.VisualStudio.Shell.12.0" publicKeyToken="b03f5f7f11d50a3a" culture="neutral" />
        <bindingRedirect oldVersion="2.0.0.0-14.0.0.0" newVersion="15.0.0.0" />
    </dependentAssembly>

Upvotes: 0

Tao
Tao

Reputation: 13996

UPDATE: more than three years later, this support has finally been added.

Download page is still http://architectshack.com/PoorMansTSqlFormatter.ashx for now.

Upvotes: 21

Andrei Rantsevich
Andrei Rantsevich

Reputation: 2935

With the permission of the PoorMans Formatter developer we have integrated it in our add-in "SSMSBoost". Recent version of SSMSBoost supports SSMS 2014, so you can use it to use Poor Man's formatter features. We have already developerd our own formatting engine, but have left "Poor Man's formatter" for backward compatibility, for those users, used to it. You will find it in formatter-styles drop-down as "Old fashioned formatting style".

Upvotes: 7

alialtansaka
alialtansaka

Reputation: 1316

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

Upvotes: 130

Karl Kieninger
Karl Kieninger

Reputation: 9129

No, it has not been updated yet.

As of 2014-04-25 the most recent built is from 2013-10-23, version 1.5.3.

http://architectshack.com/PoorMansTSqlFormatter.ashx#Latest_Changes_6

Edit:

Since I hadn't installed the plug-in on my new machine with 2014 I went a head and tried. It does not work on my fresh install, but does still on the side-by-side 2012.

Upvotes: 2

Related Questions